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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies