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.)

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