Transform two columns and a table

[PietroFarias]

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 step should I follow?

[mahoneypat · Accepted solution]

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

[PietroFarias]

@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

[HotChilli]

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.

[MattAllington]

Personally, I would use List.Zip. Make sure both are lists first. 

https://excel.city/2017/11/how-to-use-list-zip-in-power-query/