Kevin@Radstock Kevin@Radstock is offline

Member

Posts: 93

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data in columns convert to single line	PAR	Excel Worksheet Functions	1	December 18th 09 06:17 PM
How do I convert multiple columns to a single column?	scottflinders	Excel Discussion (Misc queries)	5	November 12th 06 02:13 PM
Convert one row and 50 columns of info to a single printable page	d5657	Excel Worksheet Functions	1	January 13th 05 01:17 PM
how to convert multiple columns of data into one single column?	Ah 3	Excel Worksheet Functions	1	November 12th 04 02:33 PM

All times are GMT +1. The time now is 01:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us