Home

Pivot table - summary

%3CLINGO-SUB%20id%3D%22lingo-sub-364586%22%20slang%3D%22en-US%22%3EPivot%20table%20-%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364586%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20summarise%20all%20the%20data%20on%20worksheet%20(Tracker)%20to%20show%20like%20worksheet%20(Report)%20and%20I%20have%20tried%20using%20pivot%20table%20but%20it%20is%20not%20showing%20the%20data%20that%20I%20would%20like.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-364586%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-378015%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20-%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-378015%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F299087%22%20target%3D%22_blank%22%3E%40pegzz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fdesign-the-layout-and-format-of-a-pivottable-a9600265-95bf-4900-868e-641133c05a80%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EChange%20the%20layout%20into%20the%20tabular%20form.%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-378004%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20-%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-378004%22%20slang%3D%22en-US%22%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%2F94034i44C0C6C94C3165BA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22screencap.png%22%20title%3D%22screencap.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20the%20pivot%20table%20settings%20to%20show%20the%20data%20in%20different%20columns%20like%20yours%3F%3C%2FP%3E%3CP%3EMine%20is%20like%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-366562%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20-%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-366562%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20seems%20to%20be%20one%20or%20more%20words%20missing%20in%20your%20text.%3C%2FP%3E%3CP%3EAnyway%2C%20just%20show%20the%20pivot%20table%20field%20list%20to%20see%20how%20the%20pivot%20table%20is%20set%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-365299%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20-%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365299%22%20slang%3D%22en-US%22%3EHi%20Thanks%20Detlef.%20In%20the%20pivot%20table%2C%20how%20can%20I%20items%20in%20the%20row%20into%20the%20columns%20like%20you%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364950%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20-%20summary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364950%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20data%20is%20not%20suitable%20for%20a%20pivot%20table.%3C%2FP%3E%3CP%3EIt%20should%20look%20like%20the%20table%20in%20my%20uploaded%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
pegzz
New Contributor

I am trying to summarise all the data on worksheet (Tracker) to show like worksheet (Report) and I have tried using pivot table but it is not showing the data that I would like.

 

Please help.

5 Replies

Hello

 

Your data is not suitable for a pivot table.

It should look like the table in my uploaded file.

 

Hi Thanks Detlef. In the pivot table, how can I items in the row into the columns like you?

There seems to be one or more words missing in your text.

Anyway, just show the pivot table field list to see how the pivot table is set up.

 

screencap.png

 

@Detlef Lewin 

Thanks.

How can I get the pivot table settings to show the data in different columns like yours?

Mine is like this.

 

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 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
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies