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.
Quote:
Originally Posted by dearpt
Hi All,
I have an excel sheet with text in 5 columns. I have to get all of these 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
E
|