columns to rows

[jkarennj]

How do I take data in a column and transfer it to a row format instead? I
don't want to copy/paste every cell. Thanks guys!

 

[Max]

One way, dynamically
Assuming col data running in A1 down
In B1: =INDEX($A:$A,COLUMNS($A:A))
Copy across as far* as required
*This is limited by the max no. of cols available in your excel ver, of
course

 

[jkarennj]

Hi Max.

I don't quite understand, but that's my own ignorance probably. Here's a
sample of what I have....

July 123 678
Aug 234 789
Sept 345 890

What I want it to be...
July Aug Sept
123 234 345
678 789 890

But, I can't copy ALL the data in Column A, because I have more data further
down the column that doesn't go with the information at the top of the sheet.
There are certain sections of the document I'm trying to turn from columns
to rows.

Does that make sense?

Thanks for your help - truly.

Jay

 

[Max]

Ahh, you should explained it like that ..

If the source data is in Sheet1, with top left cell in A1 ("July"),
In another sheet,
you can place this in any starting cell, say in B2:
=OFFSET(Sheet1!$A$1,COLUMNS($A:A)-1,ROWS($1:1)-1)
then just copy B2 across/fill down as far as required to achieve a dynamic
transpose linked to the source sheet

 

[David Biddulph]

Copy then Edit/ Paste Special/ Transpose