Forum Discussion
Solved
Transform two columns and a table
I have two columns (or it can be a list) with the same number of rows. I would like to create a table that has the two columns (or lists) combined as in the example in the image. Which function or st...
You can start a new blank query and use Table.FromColumns to get your result
= Table.FromColumns({Name[Name], Age[Age]})
It needs a list of table names. You can create a list from a query column with the syntax above - QueryName[ColumnName]
Regards,
Pat
You can start a new blank query and use Table.FromColumns to get your result
= Table.FromColumns({Name[Name], Age[Age]})
It needs a list of table names. You can create a list from a query column with the syntax above - QueryName[ColumnName]
Regards,
Pat
mahoneypat ,I haven't used Table.FromColumns yet and it solved my case perfectly. Thank you.
MattAllington I'm also using List.Zip, but this step does not solve it. Thank
