Combine lists to one table

[Chetcork]

Hello,

I'm working with connecting API to Power BI link to api documentation https://www.zabbix.com/documentation/current/en/manual/api/reference/sla/getsli After running query the result is 3 separate rows "periods", "serviceids","sli"  that looks like this in power bi

periods	list
servicesids	list
sli	list

I would like to convert those 3 lists to one table. I cannot share the data with you.

The end result that i would like to achive is one table that will like like the one below

service id	sli list	sli list	sli list	periods list from	periods list to
x	x	x	x	x	x
x	x	x	x	x	x
x	x	x	x	x	x

Unfortunately merging won't work because non of list has coresponding values that i can combine.

Is there a way to connect as shown?

[ImkeF]

Hi @Chetcork ,
there is a function Table.FromColumns that allows you to do something like that.
However, I would expect a table with 3 columns from your example, as you have three rows with lists (that should become columns) in them.
However, you can start with the following:
Table.FromColumns(TableName[ListColumnName])