Help with formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1930899%22%20slang%3D%22en-US%22%3EHelp%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1930899%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20data%20I'm%20downloading%20has%20locations%20named%20by%20numbers%2C%20I've%20created%20a%20table%2Fspreadsheet%20that%20has%20the%20name%20of%20each%20location%20and%20their%20corresponding%20numbers.%20I%20need%20to%20be%20able%20to%20create%20a%20pivot%20table%20or%20something%20that%20allows%20me%20to%20import%20the%20data%20and%20have%20excel%20to%20change%20the%20number%20data%20to%20name%20data%20for%20each%20location.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20assistance%20would%20be%20greatly%20appreciated%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3EJ_tiller%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1930899%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1932984%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1932984%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F881427%22%20target%3D%22_blank%22%3E%40j_tiller%3C%2FA%3E%26nbsp%3BNot%20sure%20what%20your%20intentions%20are.%20You%20created%20a%20pivot%20table%20by%20name%20and%20number%2C%20summing%20the%20numbers.%20And%2C%20based%20on%20this%20pivot%20table%20you%20created%20a%20chart.%20What%20do%20these%20numbers%20represent%3F%20Are%20the%20values%20of%20some%20kind%20or%20just%20reference%20numbers%3F%3C%2FP%3E%3CP%3ECan%20you%20describe%2Fexplain%20how%20the%20table%2Fgraph%20you%20want%20should%20look%20like%3F%20Perhaps%20like%20in%20the%20picture%20below%3F%20If%20so%2C%20delete%20the%20Work%20Location%20Number%20from%20the%20Row%20field.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-11-26%20at%2007.56.07.png%22%20style%3D%22width%3A%20388px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F236210i6A2CF7844566C065%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-11-26%20at%2007.56.07.png%22%20alt%3D%22Screenshot%202020-11-26%20at%2007.56.07.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

The data I'm downloading has locations named by numbers, I've created a table/spreadsheet that has the name of each location and their corresponding numbers. I need to be able to create a pivot table or something that allows me to import the data and have excel to change the number data to name data for each location. 

 

Any assistance would be greatly appreciated

J_tiller

1 Reply

@j_tiller Not sure what your intentions are. You created a pivot table by name and number, summing the numbers. And, based on this pivot table you created a chart. What do these numbers represent? Are the values of some kind or just reference numbers?

Can you describe/explain how the table/graph you want should look like? Perhaps like in the picture below? If so, delete the Work Location Number from the Row field.

Screenshot 2020-11-26 at 07.56.07.png