Expression.Error at pivot column step

Hi tgjones43 ,

By my research, the above error may also occur when you pivot columns with same name, please check column  names in your data source. And there is a similar thread for your reference.

https://social.technet.microsoft.com/Forums/en-US/7923e025-a0c4-407b-bd0f-65959e5038bb/what-does-this-mean-quotexpressionerror-there-were-too-many-elements-in-the-enumeration-to?forum=powerquery

Best Regards,

Cherry