Move rows into columns


T

TR53

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!
 
Ad

Advertisements

M

Mike

You will need VBA code to get this done. If you would like I could whip up a
code for you if your willing to send me a copy of your workbook?
 
S

Steve

If your information is in column A starting in A1 then in cell B1 enter
=INDIRECT("A"&((ROW()-1)*6)+1)
copy this down column B to give all "names". In cell C1 enter
=INDIRECT("A"&((ROW()-1)*6)+2)
copy this down column C for all the "titles"
etc. etc. just increase the last nuber by 1 as you go across your 6 columns

Regards
Steve
 
Ad

Advertisements

G

Gord Dibben

Assuming column A with consistent sets of data........six cells to a set.

In B1 enter =INDEX($A:$A,(ROWS($1:1)-1)*6+COLUMNS($A:B)-1)

Copy across to G1

Select B1:G1 and copy down until you get zeros.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top