Convert multiple columns into a single row

[dearpt]

Hi All,

I have an excel sheet with text in 5 columns. I have to get all of thes
in row and later take that in word. Any help is much appreciated.

This is how the excel looks

A B C D E

i have to convert this to

A
B
C
D

 

[Claus Busch]

Hi,

Am Sat, 23 Mar 2013 17:40:41 +0000 schrieb dearpt:

This is how the excel looks

A B C D E

i have to convert this to

A
B
C
D
E

copy the values => Paste special => Transpose


Regards
Claus Busch

 

[Kevin@Radstock]

Hi dearpt

Copy and transpose, or a formula, assuming data is in A1:E1:
In A2 & copy down: =INDEX($A$1:$E$1,ROW(1:1)), delete row 1.