How to convert vertically address list to horizontal

[Cathy Williams]

We imported an address list that had data stacked vertically. How do you
automate moving the data to a horizontal fomat to deal with sorting and
merging?

 

[Eduardo]

Hi,
Do copy, paste special, transpose

 

[Gord Dibben]

How consistent is the data?

Each unique addressee has the same number of entries?

Say there are 7 cells to each set in Column A

In B1 enter this formula.........copy across to H1 then copy B1:H1 down
until you get zeros.

=INDEX($A:$A,(ROWS($1:1)-1)*7+COLUMNS($A:B)-1)

If not consistent, post back with a few samples.


Gord Dibben MS Excel MVP




On Thu, 5 Nov 2009 05:45:03 -0800, Cathy Williams <Cathy