Forum Discussion
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
Yes, exactly this. As a newbie, is what you provided M Code that needs to be pasted in? I have more columns in the actual data and I am certainly not even beginner level in M Code but I may be able to add the columns based on how the sample columns were handled.
Read note below my post.