Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-22-2010, 01:42 PM
mzimmers mzimmers is offline moving data from single to multiple columns? Mac OS X moving data from single to multiple columns? Microsoft Office 2008 for Mac
Novice
moving data from single to multiple columns?
 
Join Date: Dec 2009
Posts: 6
mzimmers is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 08-23-2010, 04:00 AM
mugezhn mugezhn is offline moving data from single to multiple columns? Windows XP moving data from single to multiple columns? Office 2007
Novice
 
Join Date: Jul 2010
Posts: 16
mugezhn is on a distinguished road
Default

You can copy the data and while pasting choose a single cell and then Edit/Paste Special and choose Transpose.
Reply With Quote
  #3  
Old 08-23-2010, 05:19 AM
dariober dariober is offline moving data from single to multiple columns? Windows XP moving data from single to multiple columns? Office 2007
Novice
 
Join Date: Jun 2010
Posts: 4
dariober is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 08-23-2010, 08:20 AM
mzimmers mzimmers is offline moving data from single to multiple columns? Mac OS X moving data from single to multiple columns? Microsoft Office 2008 for Mac
Novice
moving data from single to multiple columns?
 
Join Date: Dec 2009
Posts: 6
mzimmers is on a distinguished road
Default

Quote:
Originally Posted by mugezhn View Post
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.)
Reply With Quote
Reply

Thread Tools
Display Modes


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
moving data from single to multiple columns? 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 data from single to multiple columns? 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft