Combine entries and delete entire rows

Hello,
I am quite new in the forum and hope, you can help me urgently with a handy macro to solve my problem:
In case of duplicates in first column, entries of other duplicates are merged in the second column with a separator; the row with first duplicate is kept and the rows with the remaining ones are removed.
Before:
A £ name1 address1
D $ name2 address2
C # name3 address3
A £ name4 address4
B % name5 address5
D # name6 address6

After:
A £ name1 address1
D $,# name2 address2
C # name3 address3
B % name5 address5

Many thanks in advance
Niclal

If you could upload a workbook with the before and after results it would help you get help faster.

Give this a try

Please Login or Register  to view this content.

Hello,
I am quite new in the forum and hope, you can help me urgently with a handy macro to solve my problem:
In case of duplicates in first column, entries of other duplicates are merged in the second column with a separator; the row with first duplicate is kept and the rows with the remaining ones are removed.

I dont believe so.

Try this

Please Login or Register  to view this content.

Mike,
I've got an error message: run-time error-subscript out of range, maybe because I have more that 500 rows.
In addition, I have 2 questions:
1) after merging, entries should be unique, e.g. check results for "A".
instead of:

Column1 Column2 Column3 Column4 Column5 Column6
A $;$;# Name1 city1 zipcode1 address1
C ?;%;£ Name2 city2 zipcode2 address2
D # Name3 city3 zipcode3 address3
B ? Name4 city4 zipcode4 address4

The results should be:

Column1 Column2 Column3 Column4 Column5 Column6
A $;# Name1 city1 zipcode1 address1
C ?;%;£ Name2 city2 zipcode2 address2
D # Name3 city3 zipcode3 address3
B ? Name4 city4 zipcode4 address4


2) I want to learn and so, how should the macro be changed if I have ,say, only 3 columns?

Thanks very much for your efforts

Niclal

Does this help. The runtime error is probably you dont have a Worksheet named Sheet1. Just change it in the code where comment is

Please Login or Register  to view this content.