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.

The question column should be pivoted so that each question is a new column with the associated answers from the answer column. There are also a number of other columns in the data table I want to keep in the output data table.

I have attempted resolving this in PowerBI Transform without success.

Starting example data table format

Desired example data table format