Group row in columns

[gilbertoh]

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

[NickyC]

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

[NickyC]

... 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.

[gilbertoh]

Hello, and thank your for your time.

itīs option B, on different collumns.

Sorry for not being detailed on my question.

[NickyC]

OK try this:

Please Login or Register  to view this content.