Extract value from column which consist of list

[Adi98]

The column employeeList contains of id, name, department etc. 

The Column Modified by is similar to employeeList but here I can expand the list to indivdual rows.

 How can I convert employeeList to invidual rows?

[v-easonf-msft · Accepted solution]

Hi， @Adi98 

If the column contains elements of mixed types which may result in missing expand column arrows,

you need to determine the data type of each row in the table and then convert it.

Table.TransformColumns(Source, {{"Column1", each if Value.Is(_, type list) then _ else {_} }} )

Please refer to below threads for more details.

How to expand a column that cannot be expanded in Power BI and Power Query in Excel 

Cannot expand the list values in side the column 

If each column has a list as a value, try adding the custom column below to extract the value.

try [ListColumn]{0} otherwise null

Please refer to below thread for more details.

Expanding List Type in Power BI 

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Adi98 , the first option is showing that? will that not work ?