Forum Discussion
adelmonte
Resolver I
Resolver IPivot Column Error - There were too many elements in the enumeration to complete the operation.
Hi all, I am trying to pivot a column in power query and I get an error: Expression.Error: There were too many elements in the enumeration to complete the operation. Details: [List] Any id...
I added Source name column and used uniqueness of that column to pivot and it worked fabulously 🙂
parry2k
Super User
Super UserMy code 100% made sense. It you were unable to understand and that is a different story.
it grouped the rows together. Anyhow your problem is solved that matters the most.