remove duplicate records

G

Guest

I have a similar problem. I have records with duplicate information. I need
to condense the record, however, one cell in one column is different. I want
to keep all of that cells information and remove the surrounding duplicate
information. For example:

Name Address Relatives
Joe Smith 2145 Arts Way son
Joe Smith 2145 Arts Way wife
Joe Smith 2145 Arts Way daughter

In this example, I want to condense to one line, his name, address and
relatives.
The remaining information, I want to delete it. Would a macro be best, and
if so, what is the formula?
 

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

Excel Spreadsheet Manipulation 21
"Adding" rows from one workbook to another, and expanding workbooks by row 2
Duplicate Records 2
Delete duplicates on 2nd workbook 4
combine row and the delete duplicates 2
Combining duplicate rows into one 2
Combining duplicate columns into one row 1
Find duplicates in address register 2

Top