I'm not sure which PQ problem you're referring to but separating data from reports is always going to make things more robust. You'll be able to create lots of different new tables (reports), which is relatively easy with PQ, pivot tables, formulae even. Charts too.
The column A which has numbers in is useful if there is no other way to group products for price comparison.
Do what you can re setting up a data table. It doesn't even need to be in any particular order, the reports can do that. Do make the data table a proper Excel table, it:s easier to handle table size changes (it happens automatically).
Data manipulations should be a lot easier, more robust and much less resource hungry.
So go ahead and put something together and I'll look at it next week.