I have some issue with piwot table:
My raw data looks like this. You have columns withe da same names. There are more.
But in pivot table Excel give new names: product_name, product_name1, porduct_name2.........
In that case, I cant how many product A or product B I have in raw data. I want to calculate the quantity of each product I have.
You have to combine them into one table to be able to summarize them using Pivot Tables.