Create Table from a number of lists that act as columns

[nickvanmaele]

Hi,

This forum post explains how to create a table from a list and specify the column name;

and this useful blog by @Rickmaurinus explains how to create tables based on adding rows. 

However, I am looking to create a table by glueing columns together where each column receives its value from a given list. 

Example, say that I have two lists of 5 elements each, 

• listA = {"A" .. "E"}
• listB = {1 .. 5}

By using Power Query functions and the above lists as input, how can I obtain the following table? 

ID1	ID2
A	1
B	2
C	3
D	4
E	5

I have tried variations on the following: 

Source = Table.Combine(
Table.FromList(listA,Splitter.SplitByNothing(),{"ID1"}),
Table.FromList(listB,Splitter.SplitByNothing(),{"ID2"})

)

However, Table.Combine( ) works only by adding rows together, so the above throws an error. 

No doubt that there is an easy and elegant way forward, but I can't seem to find it. 

[nickvanmaele]

Thank you. Elegant and simple.

[wdx223_Daniel · Accepted solution]

Source=Table.FromColumns({ListA,ListB},{"ID1","ID2"})