Forum

Is it possible to p...
 
Notifications
Clear all

Is it possible to pivot columns without Distinct

2 Posts
2 Users
0 Reactions
195 Views
(@marcberg)
Posts: 23
Trusted Member
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
(@catalinb)
Posts: 1937
Member Admin
 

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
Share: