Multiple Duplicate Rows to Single unique Row (Combine multiple duplicate rows to one)

[signup]

Hi,

I have a sheet with the data like below, can some one help me with a formula or something else to get the expected output?

In my sheet i have a row with the same data multiple times, i need only one row with the same data and wanted to eliminate all duplicate rows and need same rule for all rows in my sheet. Can we do this by any formula or through VB Script?

Multiple Duplicate Rows to Single unique Row:
Firm Name	Firm Alias	Office Alias	Rep Alias	TA Code	Address 1	Address 2	City	State	ZIP
Some Fund Company 1	001	002		AAA	Some Address 1		CITI 1	STATE 1	ZIP 1
Some Fund Company 1	001	002		AAA	Some Address 1		CITI 1	STATE 1	ZIP 1
Some Fund Company 1	001	002		AAA	Some Address 1		CITI 1	STATE 1	ZIP 1
Some Fund Company 2	011	022		BBB	Some Address 2		CITI 2	STATE 2	ZIP 2
Some Fund Company 2	011	022		BBB	Some Address 2		CITI 2	STATE 2	ZIP 2
Some Fund Company 2	011	022		BBB	Some Address 2		CITI 2	STATE 2	ZIP 2
Some Fund Company 3	111	222		CCC	Some Address 3		CITI 3	STATE 3	ZIP 3
Some Fund Company 3	111	222		CCC	Some Address 3		CITI 3	STATE 3	ZIP 3
Some Fund Company 3	111	222		CCC	Some Address 3		CITI 3	STATE 3	ZIP 3
Some Fund Company 4	100	333		DDD	Some Address 4		CITI 4	STATE 4	ZIP 4
Some Fund Company 4	100	333		DDD	Some Address 4		CITI 4	STATE 4	ZIP 4
Some Fund Company 4	100	333		DDD	Some Address 4		CITI 4	STATE 4	ZIP 4
Expected Output:
Firm Name	Firm Alias	Office Alias	Rep Alias	TA Code	Address 1	Address 2	City	State	ZIP
Some Fund Company 1	001	002		AAA	Some Address 1		CITI 1	STATE 1	ZIP 1
Some Fund Company 2	011	022		BBB	Some Address 2		CITI 2	STATE 2	ZIP 2
Some Fund Company 3	111	222		CCC	Some Address 3		CITI 3	STATE 3	ZIP 3
Some Fund Company 4	100	333		DDD	Some Address 4		CITI 4	STATE 4	ZIP 4

<tbody>
</tbody>

 

[mumps]

Try:

Sub RemoveDups()
    Cells.RemoveDuplicates Columns:=Array(1), Header:=xlYes
End Sub

 

[signup]

Try:

Sub RemoveDups()
    Cells.RemoveDuplicates Columns:=Array(1), Header:=xlYes
End Sub

Thank You for the reply, I'm getting 400 error while running above code. Don't we have any formula for this?

 

[mumps]

I tried the macro on the data you posted and it worked properly. Are you trying the macro on the same data?

 

[signup]

I tried the macro on the data you posted and it worked properly. Are you trying the macro on the same data?

Yes @mumps I'm trying macro on same data..

I selected data and tried to run the macro but i'm getting error. should i do it in any specific way?

 

[mumps]

Click here to download your file. Run the macro in Module1.