Excel mailing list

  • Thread starter Thread starter monica
  • Start date Start date
M

monica

I have an existing mailing list that has all fields
listed in column A. I need to separate out each row to a
column with a heading (eg: Name, Street, STate, City, Zip
+4) How can I take information from Column A and
separate each one into the proper heading?

Any suggestions would be great?
Monica
 
Monica

Is the data consistent as your example?

i.e. 5 rows

If so, enter these formulas in B1 through F1 then drag/copy down as far as you
need.

=INDEX($A$1:$A$3000,(ROW()-1)*5+1,1) in B1
=INDEX($A$1:$A$3000,(ROW()-1)*5+2,1) in C1
=INDEX($A$1:$A$3000,(ROW()-1)*5+3,1) in D1
=INDEX($A$1:$A$3000,(ROW()-1)*5+4,1) in E1
=INDEX($A$1:$A$3000,(ROW()-1)*5+5,1) in F1

If more than 3000 total original rows, change the $A$3000 to suit.

When done, copy>paste special(in place)>values.

Delete column A.

Insert a new row 1 and enter your headings.

Gord Dibben Excel MVP
 
Back
Top