Forum Discussion
Solved
Dynamic Column generation challenge
So I am needing to build a table on the fly. First the structure then I am going to fill it. On the structure, I just want to insert a column for every year from 2007 through 2058. I was trying to do...
mstarr13 ,
can transpose help
https://docs.microsoft.com/en-us/powerquery-m/table-transpose
example
Table.Transpose(Table.FromRecords({[Name = "Full Name", Value = "Fred"], [Name = "Age", Value = 42], [Name = "Country", Value = "UK"]}))