Separating the table that consists of multiple lists

[IvanS]

Hi dears,

I am getting stuck with my data coming from web in format of several Lists. PBI is then converting these into table view (see below). However, I would like to create separate table from each of the list and store it as separate table. Is it possible to do it in bulk instead of keeping only one column in the table and replicate this step 7 times?

Thank you in advance!

Ivan

[V-lianl-msft]

Hi @IvanS ,

Please try Table.FromColumns .

For more details,please refer to this video:https://www.youtube.com/watch?v=chtdQWu1MRU 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PC2790]

You can add a new step to convert your list into table using below:

Table.FromList - PowerQuery M | Microsoft Docs