Get values from the List column

Hi Anonymous,

I'd like to suggest you add a custom column with nested M query functions.

You can extract the current row as source of following operations to convert it to table. Then you can nest previous result with 'Table.Transpose' to convent the rows to columns and use the first row as table column names.

Transpose table - Power Query | Microsoft Learn

Promote or demote column headers - Power Query | Microsoft Learn

After these steps, you can do expand on this field to expand the transformed table contexts.

Optimize Power Query when expanding table columns - Power Query | Microsoft Learn

Reference documents:

Table.Transpose - PowerQuery M | Microsoft Learn

Table.PromoteHeaders - PowerQuery M | Microsoft Learn

Regards,

Xiaoxin Sheng