Forum Discussion
Pivot column error
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.
Hi mussaenda and thank you for your reply.
For sure there are duplicates, the field "Attività svolta" has few options as answers, so for different visits (CallID column) there may be the same value.
However if you look at the screenshot, the first x lines contain the same "Visual Merchandising" value for that column, the problem occur when the value changes, in the error field there should be a different value.
Hi andrearuggeri ,
Pivot only works for single value and cannot be aggregated.
If the row "Attività svolta" for that specific person then it will return as error.
check this link that tackles the issue that you are facing. it is in the last part of this link
Pivot columns - Power Query | Microsoft Learn
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.