Identify the duplicate and delete with details in excel
 

Dear Friends,

I need to delete the company name which are dulpicate, alongwith its contact
details. The data is in different row but all in 1 column.

For Example in the below table, the col A14 has to be deleted with its
contact details ie. col A15, A16, A17, A18, A19, A20 becuase it is a
duplicate of Col A1 and necessary that Col A2,A3,A4.A5,A6,A7 are duplicate to
A14 details. Hope i have not confused you.


Column A
1.Company One
2.Address 1
3.Address 2
4.Address 3
5.Telephone:
6.Fax:
7.Website URL:
8.Company Two
9.Address 1
10.Address 2
11.Address 3
12.Telephone:
13.Fax:
14.Company One
15.Address 1
16.Address 2
17.Address 3
18.Telephone:
19.Fax:
20.Website URL:


Regards

Mat