View Single Post
 
Old 08-22-2010, 01:42 PM
mzimmers mzimmers is offline Mac OS X Microsoft Office 2008 for Mac
Novice
 
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