Forum Discussion

Gongi102's avatar
Gongi102
Copper Contributor
Oct 12, 2019

Pivot table

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. 

 
excel

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Oct 12, 2019

    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