Pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-910944%22%20slang%3D%22en-US%22%3EPivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-910944%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20some%20issue%20with%20piwot%20table%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20raw%20data%20looks%20like%20this.%20You%20have%20columns%20withe%20da%20same%20names.%20There%20are%20more.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137325i43427C4B2DBB5506%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Adnotacja%202019-10-13%200010111.jpg%22%20title%3D%22Adnotacja%202019-10-13%200010111.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20in%20pivot%20table%20Excel%20give%20new%20names%3A%20product_name%2C%20product_name1%2C%20porduct_name2.........%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137324i7264A88AD622327F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Adnotacja%202019-10-13%20001011.jpg%22%20title%3D%22Adnotacja%202019-10-13%20001011.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20that%20case%2C%20I%20cant%20how%20many%20product%20A%20or%20product%20B%20I%20have%20in%20raw%20data.%20I%20want%20to%20calculate%20the%20quantity%20of%20each%20product%20I%20have.%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-910944%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-910971%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-910971%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425069%22%20target%3D%22_blank%22%3E%40Gongi102%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ELooks%20like%20you%20have%20three%20tables%20with%20the%20same%20headers%20next%20to%20each%20other!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3EYou%20have%20to%20combine%20them%20into%20one%20table%20to%20be%20able%20to%20summarize%20them%20using%20Pivot%20Tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

@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