Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Power Query: How do I convert multiple rows to comma separated values, according to their IDs?

Hi everyone! I have the following dataset: ID Colour 1 Red 1 Blue 1 Green 1 Yellow 2 Red 2 Blue 3 Green How can I transform it to the following, but it...

Need Help

Thingsclump
4 years ago
Hi Anonymous

This article explains it. You have to group it and then tweak the code little bit to join text rather than sum.

https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/power-bi-data-sources/group-by-to-merge-texts-something-like-concatenatex-but-in-queries/

Thanks,
thingsclump
www.thingsclump.com

Thingsclump

Resolver V

4 years ago

Hi Anonymous

This article explains it. You have to group it and then tweak the code little bit to join text rather than sum.

https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/power-bi-data-sources/group-by-to-merge-texts-something-like-concatenatex-but-in-queries/

Thanks,

thingsclump

www.thingsclump.com

pavel_lazarov

Regular Visitor

1 year ago

It works. Thank you!

Forum Discussion

Power Query: How do I convert multiple rows to comma separated values, according to their IDs?

Related content

Thousand-Separator-and-Decimal-Separator

Architecture decision : Separate workspaces

Small Multiples affecting separate Line Chart

MULTIPLE CARD

D3JSVisual separation between nodes