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
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies