Hi
I want to convert this to two rows:
So that it looks like this:
I've tried the usual 'group by' and pivoting, but I've got stuck!
I've also been experimenting with converting tables to lists and records..
Many thanks for looking.
Solved! Go to Solution.
Hi,
Use Table.Group with Text.Combine
= Table.Group(PrevStep, {"ID"}, {{"Values", each Text.Combine([Values],","), type text}})
Stéphane
Many thanks Stéphane!
That is really much appreciated - that saved the day 😊
Many thanks Stéphane!
That is really much appreciated - that saved the day 😊
Hi,
Use Table.Group with Text.Combine
= Table.Group(PrevStep, {"ID"}, {{"Values", each Text.Combine([Values],","), type text}})
Stéphane
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!