Row to Column

How can I take Column headers and put them in a single column?


TEST1 TEST2 TEST3 TEST4 TEST5



TEST1
TEST2
TEST3
TEST4
TEST5



Thanks in advance.

Either copy and menu:Edit>Past special>mark Transpose

or use this formula:
A1...E1:TEST1 TEST2 TEST3 TEST4 TEST5
A3: =OFFSET($A$1,0,ROW()-3)
A4: (copy the above formula)
A5: ...

Hope it helps
Ola Sandström

Thank you for the quick response.

I try, I try.. :-)