Use vlookup in a table with multiple matches

[TheLuko92]

Dears,

I have this following problem.

I have a table like the following one:

ID Comment
001 Hello
001 Try
002 asd
003 -
003 bye

What I would like to get is:
001 Hello ; Try
002 asd
003 - ; bye

How can I do?

Thank you,
Luca

[63falcondude]

Hello and welcome to the forum.

One way to do this would be by using Power Query (Get & Transform).

1) Highlight your data > Data > From Table > Check the "My table has headers" box > OK
2) Delete the "Changed Type" applied step to keep the leading 0's
3) Group By > Group by: ID > New column name: Temp > Operation: All Rows > OK
4) Add Column > Custom Column > formula Table.Column([Temp],"Comment") > OK
5) Click on the button to the right of the Custom header and select Extract Values > Semicolon > OK
6) Select the Temp column > Home > Remove columns > Close & Load

See attachment.

[TheLuko92]

Thank you for your support, it worked!

[63falcondude]

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.