how do I move data in prexisting rows to columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have ranges of data in rows. I want to arrange the data in columns. How do
I go about it?
 
darryl said:
I have ranges of data in rows. I want to arrange the data in columns. How do
I go about it?
Click to expand...

Hi Darryl,

Maybe you can use the Transpose option under Paste Special.

Select your data -> Edit -> Copy.
Then select where you want your data and go to Edit -> Paste Special
and tjeckmark Transpose and press OK.

Regards,
Bondi
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Rows to Columns 3
Compare identifier columns from 2 sheets - remove rows that are dups 2
How to find a value with multi-column, multi-record list 1
Data moving 3
selecting data in a row 4
Need suggestions on layout to report/pivot 3

Back
Top