Combining Rows based on the ID of that table

[Adam01]

Hello!

I am wanting to combine values based on the unique ID of that table, so for any values that have the same ID I want them to be pushed into the same cell. To explain this better I've included 2 screenshots labelled Old and New. Would I use Power Query or something to do with pivoting or grouping columns rows based on a column value? Unsure where to start 

 Old (Table I have currently)

 New (Table I would like to have)

[Syndicate_Admin]

Hello Syndicate_Admin

Can this be done twice or more? Can you Group by ID and Date and Order Number all at once?

[AlexisOlson · Accepted solution]

You can do this with a small tweak to Group By.

Click Group By under the Home tab and group by ID taking the max over Value.

This generates code that looks like this:

= Table.Group(#"Changed Type", {"ID"}, {{"Value", each List.Max([Value]), type nullable text}})

We don't actually want List.Max though. Replace that with Text.Combine like this:

= Table.Group(#"Changed Type", {"ID"}, {{"Value", each Text.Combine([Value], ", "), type text}})

[cbennett5199]

Perfect! Thank you!

[chanpreet_90]

how to combine if the column has text and number both?

[Adam01]

Thank you! This is exactly what I needed