Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
21
Views
Topic starter
Hello,
I saw in the advanced editor that when i use the pivot function of Power Excel that this creates a list.distinct statement.
In my case this distinct deletes some occurences which i need for my calculation.
No my question is, is there a syntax to pivot a column without the distinct option ?
Thanks In Advance,
My best regards,
Posted : 11/08/2021 3:40 am
List.Distinct is essential, creates unique column names, there cannot be duplicate column names.
Most probably what you need should be done in a different way, you'll have to clarify what you need to do.
Posted : 11/08/2021 4:31 am
