Pivot grouping issue?
I have an issue with the pivot and I'm not sure how to solve this or what function to use to get a similar arrangement!
I would like to arrange my dataset so that I see all vendors in one column grouped and all the other data columns arranged in further columns:
Normally the column selected as the "pivot ID" should be grouped (=deduplicated) but it seems that it is not grouping the values even though they are the same:
The weird thing is that for some values the group works and it is arranging it as expected:
Is there anything I can do to make the group work in the pivot?
Feel free to suggest any other solution (other than pivot)!