Excel problems

[Stormbringer]

Ok, I have a table in excel which is like this:

A B C D E
1 2 3 4 5
6 7 8 9 0

and I need to turn it so it is like this:

A 1
B 2
C 3
D 4
E 5

A 6
B 7
C 8
D 9
E 0

and so on. The table is pretty big, so it will take a long time to do by hand. Anyone here knows a way to do it?
I could post a file and if someone wants to give it a try I would really apreciate it.

 

[ainwood]

Select the cells. Choose 'copy'.
Select the destination. Choose 'paste special' then on the dialog that comes up, choose 'transpose'. Hit OK.

 

[Stormbringer]

I love you ainwood, you just saved me 3 hours of work!

 

[Abulafia]

For your information...

You can also make use of the TRANSPOSE function as an array.

i.e.

• Select the cells you want the text to move into
• In the formula bar, put =TRANSPOSE and then, in brackets, put the range you are transposing
• In the formula bar, hit Ctrl+Sift+Enter

You have created a transposed array.

 

[Abulafia]

If you ever find yourself needing to automate Excel further then come along to VBA Express - it's run by a bunch of MS Office Experts and even some Microsoft MVPs.