Loop through a list of tables where the values need to be transponed for each table

[dvdbroek]

Dear PowerBI Kings and Queens,

Currently i'm working with an API call / data set wich gives me an list / table wich contains sub tables:

Each table contains 2 text values:

The task im trying to complete is to make a singel table where the values of each sub tables are transposed like below:

Column1 |  Column2

   Row1          Row2

If I expand the higher table at once I get a list like below:

Could someone help me or have the solutions for my problem?

Much thanks in advance!

 

[dvdbroek]

Thnx it worked perfectly!

[Ahmedx · Accepted solution]

to know how to do this watch my video

= Table.TransformColumns(
#"Removed Other Columns" , {"Custom", (x)=> Table.FromRows({ Table.ToList(x)})
})

https://1drv.ms/v/s!AiUZ0Ws7G26Ri15AJLAtinpjwfR6?e=YWSUhL