PowerBI – How to pivot answer lists to column answers
In PowerBI, I have a data table which includes a question column and an associated answer column.
In the answer column there are a mixture of lists (lists may contain one or more answers) and non-list values.