Hi Mynda,

I get an expression error column1 not found when I load to pivot table report but not when I load to table.  

I have been back to all the steps in the query but can't find the error. 

I'm attaching the s/sheet with query.  You will see I've loaded to table and created a pivot table but for my own piece of mind would like to know how to fix the error that prevents from loading directly to pivot table report.

tnx

Tracy.