#1
|
|||
|
|||
moving data from single to multiple columns?
Hi -
I received some data from an email. When I copied it, and pasted it into Excel, it put everything into one column. Is there some slick way to tell Excel to move the data into seven columns? R1C1 stays as is, R2C1 goes to R1C2, R3C1 goes to R1C3, and so on, starting over with the 8th row. Alternately, is there a better way to import the data so this would be unnecessary? Thanks. |
#2
|
|||
|
|||
You can copy the data and while pasting choose a single cell and then Edit/Paste Special and choose Transpose.
|
#3
|
|||
|
|||
Also have a look at:
Data -> Text to Columns -> (Wizard) Either the option Delimited or fixed width should suite you, depending on your data. Dario |
#4
|
|||
|
|||
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 |