Pivot column - Don't aggregate

[Anonymous]

HI, 

I have three column table and I need to Pivot column no.2 so I get list of values. But when I select column and apply pivot and Don't aggregate I get Error where lists in column should be?

I have seen one solution of @Aydin Alyev https://www.youtube.com/watch?v=B9_jHZrmkHo but I do not know how to apply it to three column thing ? Help please, thanks

[Anonymous · Accepted solution]

Solved, all columns must be promoted as text data. Probably bug.