Merge rows according to unique IDs in column A- with multiple columns

Hi!
I have a giant (27K rows) worksheet I need to combine rows for.
I have data with duplicate IDs in column A and some data in columns B-S. I need to reduce all the duplicate IDs into a single row for each ID while merging the values in columns B-S into a single cell delimited by a comma. It would be a bonus if I could choose the delimiting character.
It would also be a BIG bonus to be able to delete duplicates.

I found a very similar function in Jerry Beaucaire's awesome "Excel Assistant" - https://sites.google.com/a/madrocket...ons/merge-rows
but it will only work for 2 columns, and I have 18.

Does anyone have a VB function that would work in my case? Or knows of one?
I cannot change the code myself as I have not programmed in years, and never in VB...

Thank you so much, and have a lovely weekend!

Please down load a sample book. Go in to advance, them attachment

I created a demo file (can't upload the real one since it has confidential patient information). So it's much smaller, but will convey the idea.

You can see that I have different values in columns M,N,Q,R. In other columns the data will always be the same for each patient.

Thank you in advance,
Inbar

I assume you have windows, not mac.

True. Win8.

True. Win8.

thanks for the quick reply!
it's not what I hoped for, for two reasons:
a. duplicates were not removed
b. all of the columns are now merged into one column

my desired output is like in the attached file.
I'm not even sure it CAN be done, but if it is- it will make my life a whole lot easier!

tnx

Inbars,
No, the code does not copy duplicates as long as they are in column A, but you may be right that that was not you had expected result. I have now added another different code and different outcome. The rows are the same for both codes. The output is the same as the input-Same sheet1.

Thanks for the help,
I was also emailing Jerry Beaucaire (owner of "Excel Assistant" - https://sites.google.com/a/madrocket...xcelassistant/ ) - and he modified his code so it will also work for multiple columns.
Thanks Jerry!
(I don't know if it's OK for me to post his new code here, but I'm sure he'll put it on his website for future reference).

Have a good weekend everyone!

inbars,
Please post it here, so that myself and other users and members will benefit.