merging spreadseets

[jojo9363]

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

[#2]

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.

[#3]

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

[#4]

Thank you!@Martin_Weiss 

[#5]

Thank you!!