Data from rows ==> columns

[opelcorsa]

Hallo,
In sheet 1 I have noted in cells A1, B1, C1, .... the names of m
columns.
Now I am looking after the possibility to have in sheet 2 in column A
list of als this names. So A1/sheet 1 has to appear in A1/sheet2
B1/sheet1 in A2/sheet2, C1/sheet1 in A3/sheet2, and so on.
Has any body a solution to execute that?
A lot of thanks.
Greetings..

 

[Ken Wright]

Copy A1:Z1 from sheet 1, Go To sheet 2 A2 and do Edit / Paste Special /
Transpose

 

[AlfD]

Hi!

Have a look at copy followed by PasteSpecial with the Transpose optio
selected.

Al