Merging Multiple Row Values Into One

[bencruz7]

Hi,

How can I merge the example below into one single row with the third column being the merged, contatenated value?

Thanks!

[AlienSx · Accepted solution]

Hi, @bencruz7 

    Table.Group(
        your_table, 
        {"Account ID", "Health Plan: Record Type"}, 
        {{"Payer: Name", each Text.Combine([#"Payer: Name"], ", ")}}
    )

[bencruz7]

This worked! Thank you so much!