Forum Discussion

PietroFarias's avatar
PietroFarias
Resolver II
5 years ago
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...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

HotChilli's avatar
HotChilli
Community Champion
5 years ago

Add an Index column in Power Query to both columns. (Both should start from the same number e.g.1)

Merge the tables using an Inner Join.