How do I transpose multiple rows into columns?

  • Thread starter Thread starter Nick
  • Start date Start date
N

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!
 
Copy > PasteSpecial > Transpose.........as many times as you need......can be
set to a macro if done frequently..

Vaya con Dios,
Chuck, CABGx3
 
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?
 
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
 
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)
 
Back
Top