View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Britt3 Britt3 is offline
external usenet poster
 
Posts: 2
Default printing mailing labels when data is in rows

I have a spreadsheet that displays my customer data in rows like a mailing
label.
1 Customer name
2 Customer Address
3 City, State Zip
4
5
6 Customer Name
7 Customer Address
8 City State Zip
9
10

All the data is in one column and the data format repeats every 6th row. So
I have five rows of name and address data for one entry then five more rows
of data for the next entry and so on. How can I reformat data into columns
for mail merging or print to mailing labels using the current layout?

Britt3