Prashantb

Junior Member

Posts: 1

Need to have data in one column

I have below data in my excel sheet:--

user1 a1 a2 a3
user2 b1 b2 b3
user3 c1 c2 c3

and i need it this way:--

user1 a1
user1 a2
user1 a3
user2 b1
user2 b2
user2 b3
user3 c1
user3 c2
user3 c3

Can anyone please help me in this...

Thanks in advance..!

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
Moving data from column to row in groups of 250 per row for fourrows, then skip a row and continue the same throughout the data in column A	Eric Hess	Excel Programming	1	July 11th 11 11:35 PM
Search for a column based on the column header and then past data from it to another column in another workbook	minkokiss	Excel Programming	2	April 5th 07 01:12 AM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look	[email protected]	Excel Programming	2	December 30th 06 06:23 PM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look	[email protected]	Excel Discussion (Misc queries)	1	December 27th 06 05:47 PM
Matching one column against another column of data to show the same amount of data.	dodat	Excel Worksheet Functions	0	December 30th 05 06:19 PM

All times are GMT +1. The time now is 03:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us