Power Query Expand Multiple List columns at a time

[LP2803]

Hi Team,

I have the data as below.

When I expand to New Records, the List in "column1.videoIn", I get a list of Records

When i expand the Records i get the below list of columns

Post this, I again get list for the columns that i expanded. 

These lists are further expanded with "Extract Values.." option.

So the question is, I have 8 -10 columns where these above expansions are required. Any idea how this can be done dynamically and fast instead of going to every column and expanding it?

[Anonymous]

Hi @LP2803 ,

Sorry for that it's not very clear.

Can you share some sample data and the expected result to have a clear understanding of your question?

You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

Best Regards,
Yuna