Forum Discussion

laganlee's avatar
laganlee
Icon for Helper II rankHelper 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's avatar
    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's avatar
    laganlee
    2 years ago

    Hi Olga,

    That's fantastic! 

    That's saved the day ðŸ˜Š

    Many thanks