i've got these three columns like in the attach.
Column two needs to be transformed into Pivot Column, but I get error when doing so.
There was a topic here and a guy said it all columns should be promoted as text, didnt solve it though, or I didnt understand him.
Solved! Go to Solution.
Only the Pivot column needs to be text; however if you use the menu-option to pivot on a non-text column, the generated code will take care of the transformation to text. Then again: it is not the most nice-looking code, so I would recommend to transform the pivot column to text before pivoting.
You have duplicates. This is not allowed with option "Don't aggregate".