Pivot column - Dont aggregate

[alxmti]

Hi,

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.

Regards

[MarcelBeug]

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".

[alxmti · Accepted solution]

thanks for the hints.

the solution is withing this video (although he uses two columns only, it works with a third).

https://www.youtube.com/watch?v=B9_jHZrmkHo