columns to rows
 

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!

columns to rows
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jkarennj" wrote:
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!

columns to rows
 

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" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jkarennj" wrote:
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!

columns to rows
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jkarennj" wrote:
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

columns to rows
 

Copy then Edit/ Paste Special/ Transpose
--
David Biddulph

"jkarennj" wrote in message
...
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!