convert column and row

[melody]

How can I convert column and row in excel? E.g.
column1 column2 column3
a a1 a2 a3
b b1 b2 b3

I want this format:
a b
column1 a1 b1
column2 a2 b2
column3 a3 b3

Thanks in advance

 

[DavidObeid]

Highlight an area that is the same size as the array you want t
transpose in the shape you want.

Eg, if you original array went from A1:C2 your array is 2 by 3

Highlight an area that is 3 by 2 (say E1:F3)

type =transpose(A1:C2) and press Ctrl+Shift+Ente

 

[Dave Peterson]

Select your range and then Edit|copy

Select a different cell not in the original range
edit|paste special|and check the transpose box.