How do I transpose multiple rows into columns?

[Nick]

I have data organized (in Office 2007) as such:

A
B
C

D
E
F

and so on

I want to tranpose it so it appears in columns as:

A B C
D E F

and so on.

Is there a way to transpose multiple rows so the information is stacked into
columns?

Thanks a million!

 

[CLR]

Copy > PasteSpecial > Transpose.........as many times as you need......can be
set to a macro if done frequently..

Vaya con Dios,
Chuck, CABGx3

 

[Nick]

Thanks. If the information in the rows is different for each set, is there a
way to copy and paste one time, or will I have to do it multiple times?

 

[CLR]

Multiple times, unless you are talking about MANY of them, or doing the whole
thing frequently, then a macro would be best........if you're talking about
something like names and addresses, someone has probably already done a macro
to do the job. If you can't find one, post back with more specifics and
someone will help.

Vaya con Dios,
Chuck, CABGx3

 

[RagDyer]

Is there a blank row between C and D in your original datalist?

 

[Nick]

No

Is there a blank row between C and D in your original datalist?

 

[RagDyer]

Say your datalist is in Column A,
Enter this formula *anywhere*, copy across 3 columns, then copy down as
needed:

=INDEX($A:$A,3*ROWS($1:1)-2+COLUMNS($A:A)-1)

If you data would be in, perhaps, J20 to J100, then the formula would be
adjusted to:

=INDEX($J$20:$J$100,3*ROWS($1:1)-2+COLUMNS($A:A)-1)

 

[Evgeny Grischenko]

Dear Nick,
i have used an add-in "tables transformer" to make columns out of rows, the
link to it: http://www.office-excel.com/excel-addins/tables-transformer.html
Try it out, maybe it helps you too.
Best regards,
Evgeny