November 7, 2021
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.