I want to pivot a column but Power BI adds nulls.
I selected the column ‘Question’ and selected ‘pivot column’ then selected ‘Response’ with no aggregation but Power BI added nulls. Is there a way to prevent this? I spent the whole day on this and I am sure there this a simple solution. Thanks for your help in advance.