Group By

Hi AndreaLH , is this what you are looking for? 

If this is similar to what you'd like to achieve, I'll share a snippet of the M code for reference.

In this partcular scenario, I've taken just the Member name column for the text column. In case you wish to take more columns and combine them, I'll leave the code for that below. (Use another nested list in Grouping Function and use the below function)

List.Transform(Table.ToColumns(Table.RemoveColumns(_,NumericCols)), each Text.Combine(_,",")). Thanks