Forum Discussion
mstarr13
Microsoft Employee
Microsoft EmployeeDynamic 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...
amitchandak
Super User
Super Usermstarr13 ,
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"]}))