Oct 12 2019 03:23 PM - edited Oct 12 2019 03:29 PM
Hi,
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.
Oct 12 2019 07:52 PM
Hi,
You have to combine them into one table to be able to summarize them using Pivot Tables.
Regards