merging spreadseets

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3164563%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3Emerging%20spreadseets%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3164563%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20was%20wondering%20if%20I%20need%20a%20special%20addition%20to%20my%20excel%20in%20order%20to%20merge%20several%20spreadsheets%20ino%20one.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3164563%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EOffice%20365%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

I was wondering if I need a special addition to my excel in order to merge several spreadsheets ino one.

4 Replies

Hi @jojo9363 

 

since you use Office 365, you do not need any additions. The functionality you need to use is called Power Query (Get & Transform) and is located in the Data-menue.

But you need to get at least some basic knowledge about Power Query.

 

If all worksheets have an identical structure, you could alternatively use the consolidate functionality, which is also located in the Data menue.

You can do this in Power Query using the merge queries functionality

Thank you!@Martin_Weiss 

Thank you!!