Home

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
Gongi102
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

@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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies