Table.Group Dynamically Columns

[JustDavid]

Power Query Gurus,

I have a step below where I'm grouping all columns that has 'Column#' where # is a number from 2 onwards.

= Table.Group(Custom1, {"#"Remove Top Rows"}, 
{
  {"Column2", each List.Sum([Column2]), type number}, 
  {"Column3", each List.Sum([Column3]), type number}, 
  {"Column4", each List.Sum([Column4]), type number}, 
  {"Column5", each List.Sum([Column5]), type number}, 
  {"Column6", each List.Sum([Column6]), type number}, 
  {"Column7", each List.Sum([Column7]), type number}, 
  {"Column8", each List.Sum([Column8]), type number}, 
  {"Column9", each List.Sum([Column9]), type number}, 
  {"Column10", each List.Sum([Column10]), type number}
}
)

My question is how do I make them dynamic, so that in a sense, if tomorrow instead of Column2 to Column10 becomes Column2 to Column5  or  Column2 to Column 15, it can automatically assign it so that the M code doesn't breaks.

Edit: Able to resolve by google and answer is also in this forum.

Power Query Group by aggregation with dynamic column names 

Modified the code to my own fit

Table.Group(#"PreviousStep", {"Custom"}, 
   List.Transform(
      List.Difference(Table.ColumnNames(#"PreviousStep"), {"Custom"}), 
      (l)=> {l, each List.Sum(Table.Column(_, l)), type number}
   )
)

Thanks

[JustDavid · Accepted solution]

Per Dino Tao's recommendation so as to mark this thread as solved.

Table.Group(#"PreviousStep", {"Custom"}, 
   List.Transform(
      List.Difference(Table.ColumnNames(#"PreviousStep"), {"Custom"}), 
      (l)=> {l, each List.Sum(Table.Column(_, l)), type number}
   )
)

[Anonymous]

Hi @JustDavid ,

I'm glad you found a solution!
I suggest you revert with a new reply below with your answer and mark it as a solution, as posts that have been solved will be easier for other users to find, and perhaps you can help more users who are facing the same problem, thank you!

Best Regards,
Dino Tao