Hello,

I have a data model in power query that generates some kind of list of combinations.

I created to some point the model but I have a step that I don't know how to do.

I need to expand all the columns named from 1 to a total number of rows  (the number of columns is variable). rows are from the input table

Expand to new rows I need, yes it will be a really long list that is what I want

the file is attached.

Important1: expanding step by step is not acceptable because the number of columns will vary.

Important2: I am not a beginner please do not treat me like that.

I was thinking to make this with "try" and "otherwise" but I think there are better solutions.