Conceptual help using external data

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3171542%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EConceptual%20help%20using%20external%20data%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3171542%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20need%20to%20use%20a%20shared%20spreadsheet%20which%20%3CSTRONG%3Ecannot%26lt%3B%5C%2FSTRONG%26gt%3B%20be%20modified.%26lt%3B%5C%2FP%26gt%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20for%20me%20to%20reference%20the%20external%20data%20and%20add%20additional%20columns%20in%20another%20spreadsheet%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EIn%20addition%2C%20the%20external%20data%20is%20really%20messy.%26nbsp%3B%20I%20created%20a%20pivot%20table%20in%20my%20spreadsheet.%20I%20assume%20I%20can't%20add%20data%20to%20the%20pivot%20table.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ECan%20you%20recommend%20how%20I%20can%20work%20with%20this%20data%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3171542%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

I need to use a shared spreadsheet which cannot be modified.

 

Is there any way for me to reference the external data and add additional columns in another spreadsheet?

 

In addition, the external data is really messy.  I created a pivot table in my spreadsheet. I assume I can't add data to the pivot table.

 

Can you recommend how I can work with this data?

1 Reply

@nilanjenator PowerQuery could be a good starting point. You may find the link below helpful to get started.

https://exceloffthegrid.com/power-query-introduction/