Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-1516468%22%20slang%3D%22en-US%22%3EPivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516468%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Jaquewalves_0-1594491240136.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204772iBA02BFF980F57AAD%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Jaquewalves_0-1594491240136.png%22%20alt%3D%22Jaquewalves_0-1594491240136.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EGuys%2C%20Please%20what%20do%20you%20tell%20me%20to%20do%20with%20this%20spreadsheet%3F%20I'm%20trying%20to%20use%20it%20in%20the%20Pivot%20Table%20function%2C%20but%20it%20doesn't%20recognize%20my%20customer%20satisfaction%20survey%20questions%20above%3F%20Someone%2C%20please%20send%20me%20advice%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1516468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516472%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516472%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F725700%22%20target%3D%22_blank%22%3E%40Jaquewalves%3C%2FA%3E%26nbsp%3BNot%20sure%20what%20you%20have%20in%20mind%20but%20perhaps%20start%20by%20inserting%20a%20blank%20row%20above%20row%202.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516499%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516499%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you.%20I%20will%20try%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Jaquewalves_0-1594491240136.png

Guys, Please what do you tell me to do with this spreadsheet? I'm trying to use it in the Pivot Table function, but it doesn't recognize my customer satisfaction survey questions above? Someone, please send me advice? 

2 Replies

@Jaquewalves Not sure what you have in mind but perhaps start by inserting a blank row above row 2.

Thank you. I will try @Riny_van_Eekelen