Forum Discussion
Extracting List Values when single values are present
Hi Anonymous
You might refer to these similar posts:
Hi Anonymous ,
you can apply the following transformation on your column to transform everything in it to a list:
Table.TransformColumns(Source, {{“Column1”, each if Value.Is(_, type list) then _ else {_} }} )this blogpost explains it: https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi-and-power-query-in-excel/
Hi Anonymous
You might refer to these similar posts:
Thanks. When I tried to split delimiter in Edit Queries, I get this error:
Expression.Error: We cannot convert a value of type List to type Text.
Details:
Value=List
Type=Type
Still looking into the other resources you sent.
Anonymous
Please post sample data and screenshot of what you have tried so far to better resolve the problem.
Hi Anonymous
You are encountering this error because you are trying to split the columns that contains null values.
You can replace null with any value then try splitting again based on your conditions
