Table grouping with unknown quantity of columns

[Taurus]

Hi all

I have this query:

I want to group by "Category" column and  aggregate (summ) all other columns (Column3, Column4 ... ColumnN), but the N (number of columns) is not known before (this columns appear after applying Table.Transpose)

I can see that grouping is like this

Table.Group(#"Prev step", {"Category"}, {{"Column3", each List.Sum([Column3]), type number}})

I want to use list of columns (got by Table.ColumnNames) instead "Column3" and use some kind of list instead of hard reference in List.Sum([Column3])

Is that possible? If not, what is trobleshooting?

[TomMartens · Accepted solution]

Hey,

before you start thinking about grouping your rows by the category column, unpivot the other columns:

https://www.youtube.com/watch?v=Kbu5RkUo6-k

Hopefully this provides you with some ideas.

Regards,

Tom