Forum Discussion
Extracting List Values when single values are present
Hi,
I am trying to find a way to extract list values in a column, but the situation is unique. Some cells contain a list with multiple values, some contain a single value, and some contain a blank value, as shown below. Is there a way to extract the list values so they display in their own columns? I suspect all cells in the column would need to be [list] but want to see if there are any ideas out there.
Could not insert screenshot for some reason 😕
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/
9 Replies
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/
Anonymous
Did you try Split columns with delimiter option in Edit queries?
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=TypeStill 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.
