Pivot table

Copper Contributor

Hi,

 

I have some issue with piwot table:

 

My raw data looks like this. You have columns withe da same names. There are more. 

 

Adnotacja 2019-10-13 0010111.jpg

 

But in pivot table Excel give new names: product_name, product_name1, porduct_name2.........

 

Adnotacja 2019-10-13 001011.jpg

 

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. 

 
1 Reply

@Gongi102

 

Hi,

 

Looks like you have three tables with the same headers next to each other!

You have to combine them into one table to be able to summarize them using Pivot Tables.

 

Regards