Forum Discussion
Get values from the List column
Just adding few screenshots for the explanation:
The Column name is "Components" which has List values and below is the record
How can I retreive the name from here and store it in a new column in the query?
Thanks
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