Forum Discussion
Solved
Pivot column error
Hi all, I have this dataset imported from Sharepoint and I need to pivot for "Question Caption" column but when I do it, with "RealAnswer" as Value and Don't aggregate option, I get ...
yes there are multiple ways to do that.
Option 1 is to add 1 from the "Attività svolta" if there is a duplicate before pivoting.
Option 2 is to put together the answers in one row for "Attività svolta" if there is any duplicate before pivoting.
OMG
Is there an alternative way?
What I need to achieve is to have values from "Question caption" as new columns and values from "RealAnswer" as actual values for each row (exactly what pivot does)
yes there are multiple ways to do that.
Option 1 is to add 1 from the "Attività svolta" if there is a duplicate before pivoting.
Option 2 is to put together the answers in one row for "Attività svolta" if there is any duplicate before pivoting.