You know how cumbersome pivot tables can be... so for instance if I wanted to have more columns with new data, calculations and manipulations, I would indeed need to copy paste all values. This may be an acceptable solution if you only perform the analysis once, but it's quite possible I'll add more records to the original list, etc. So I'll have to re-do the pivot table, copy & paste again, and so on.

Thanks for the help again. I'm sorry I don't have enough reputation to go around!

Quote Originally Posted by Norie View Post
ANS

How would the pivot prevent/hamper further analysis?

If you really don't want the pivot then just copy the results from it, paste them somewhere and delete the pivot table.