Posts: n/a

Is it possible to transpose 2 columns of data into 1 row?

I have the following spreadsheet:

1 a
2 b
3 c
4 d

I would like to have this format:
1 a 2 b 3 c 4 d

Any suggestions would be greatly appreciated!!

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
change data in rows to be viewed in columns	CHET	Excel Discussion (Misc queries)	1	March 10th 05 09:16 PM
Merging columns of data	Frank D. Nicodem, Jr.	Excel Discussion (Misc queries)	0	March 4th 05 08:16 PM
Trying to transpose linked data using Paste Special	Mike	Excel Worksheet Functions	2	January 28th 05 05:26 PM
How to get pivot table data columns instead of rows	Jessica	Excel Discussion (Misc queries)	0	January 19th 05 04:29 PM
Pulling data from 1 sheet to another	Dave1155	Excel Worksheet Functions	1	January 12th 05 05:55 PM

All times are GMT +1. The time now is 11:24 PM.

About Us

"It's about Microsoft Excel"