moving data from single to multiple columns?

mugezhn · #1 08-23-2010, 04:00 AM

You can copy the data and while pasting choose a single cell and then Edit/Paste Special and choose Transpose.

mzimmers · #2 08-23-2010, 08:20 AM

Quote:

Originally Posted by mugezhn

You can copy the data and while pasting choose a single cell and then Edit/Paste Special and choose Transpose.

I don't get Transpose as an option for Paste Special; all I get is the option to paste it as Unicode. (I'm cutting from Mac Mail, BTW.)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I do this? sorting data in seperate columns	shumonsaha	Excel	0	07-04-2010 03:05 AM
how to center text in multiple columns	galiwock	Excel	1	05-12-2010 09:02 AM
Pasting multiple photos - one photo per cell in a single oepration	mccruise	Word	0	04-07-2010 04:13 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM
multiple colums under a single column	RobotChicken	Excel	3	01-06-2010 09:17 AM