Quick Excel Question

[EpsiIon]

If have data formatted like this:

a b c d e f g h i
1 2 3 4 5 6 7 8 9

How do I get it to look like this:

a 1
b 2
c 3
d 4
e 5
f 6
g 7
h 8
i 9


Thanks a lot!

Epsilon

 

[Anubis]

just copy the rows and paste them vertically

 

[EpsiIon]

Thanks, got it!