Forum Discussion

Icon for Helper II rank

Helper II

2 years ago

Solved

Change a column to delimited rows grouped by another column.

Hi all,

I need to change a column to delimited rows grouped by another column.

It's easier to say it by a picture! :

Many thanks for looking!

olgad
2 years ago
Hi,
Select column B, then Group By

Replace the part : each Text.Combine([A], ",")

Here is the code:

= Table.Group(#"Changed Type", {"B"}, {{"A", each Text.Combine([A], ","), type nullable text}})
laganlee
2 years ago
Hi Olga,
That's fantastic!
That's saved the day 😊
Many thanks

2 Replies

olgad
Resident Rockstar
2 years ago
Hi,
Select column B, then Group By

Replace the part : each Text.Combine([A], ",")

Here is the code:

= Table.Group(#"Changed Type", {"B"}, {{"A", each Text.Combine([A], ","), type nullable text}})
- laganlee
  Helper II
  2 years ago
  Hi Olga,
  That's fantastic!
  That's saved the day 😊
  Many thanks