Group row in columns

Hello, I have an excel table like:

name1 A
name2 B
name3 C
name2 C
name3 A
name4 A
name1 B
name1 C

and I need to group them like:

name1 A B C
name2 B C
name3 C A
name4 A

Hi
I'm assuming that the names are on column A and the A,B, C etc are in column B, is that right?

also, do you want the output "A B C" as a string in column B, or as separate values "A" "B" "C" in columns B-D

... assuming option 1, run a sort on your table sorting first by name, so all the identical names are in successive rows, then try this macro:

Please Login or Register  to view this content.

Hello, and thank your for your time.

itīs option B, on different collumns.

Sorry for not being detailed on my question.

OK try this:

Please Login or Register  to view this content.