Merging Multiple Row Values Into One

[Anonymous]

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, @Anonymous 

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

[Anonymous]

This worked! Thank you so much!