How to combine information from multiple rows into one

Z

Zuzie

Hi, I have a spreadsheet with multiple (duplicate) rows which I would like to
combine into one. The spreadsheet lists name/address of a customer and also
anyone else who may be living with them in the same property. I would like to
mail merge the file and send a letter to each customer listing who we think
lives in the property. Here is an example:

Current file:

Mr Peter Smith, 1 Nowhere Street, Amy Smith
Mr Peter Smith, 1 Nowhere Street, Tracey Smith
Mr Peter Smith, 1 Nowhere Street, Tim Smith

The new file should show 1 row as:

Mr Peter Smith, 1 Nowhere Street, Amy Smith, Tracey Smith, Tim Smith
 

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

Similar Threads

How do I combine records from different sources 0
Trying to merge data from mulitple rows to one. 1
Combine multiple columns and rows for one record into one row. 2
Mail Merge Multiple Records 5
How to join row data into one row 1
How to mail merge multiple rows in one document 0
Getting Data from one spreadsheet into another 2
Linking Multiple Rows to Use in Mail Merge 4

Top