View Single Post
  #1  
Old June 4th, 2010, 08:34 PM posted to microsoft.public.excel.misc
TR53
external usenet poster
 
Posts: 1
Default Move rows into columns

I have an Excel sheet that has 8000+ rows that include contact information.
I'd like to move them from all of those rows into 6 columns. Currently it
lookzs like:

name
title
company
address
city/state/zip
phone
....
....
....

And I'd like to create a formula to move it to 6 columns that look like this:

name title company address city/state/zip phone

I'm still an Excel novice but would appreciate any suggestions you might
have. Thanks!