# How do I transpose multiple rows into columns?

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!

C

#### CLR

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

Vaya con Dios,
Chuck, CABGx3

N

#### 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?

C

#### 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

R

#### RagDyer

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

N

#### Nick

No

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

R

#### 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

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