Combine & Unpivot Tables Multiple Excel Files in Folder

https://youtu.be/D7IR5GuIEPk

Getting files from your co-worker or from a system and need to combine or join them together? Easy to do if you have a few file; it's a simple copy and paste. Even if you have to transform you data by unpivoting your table it's not a hassle. But if you've got over five files or it's a recurring process, it becomes a burden to do. Power Query can do all this in a semi automated way to solve your problem.

Combine and Unpivot Tables Multiple Worksheets Power Query Function

When you have multiple worksheets or tabs to combine together, it's not a difficult process to copy and paste. However if you need to transform the table in those worksheets, like unpivoting it; still is not that bad albeit it'll take a bit more work to transpose the columns and rows. Now if you had to do this to a LOT of worksheets or if you had to do this on a recurring basis, it becomes a pain to do this. The solution is to have Power Query automate these steps; and it can future proof it by incorporating new data.

Use Power Query Parameter to Quickly Filter

https://youtu.be/gFqlfSckc5s

This video will introduce you to using the parameter feature in Power Query. You can use parameter to pass values to other parts of your query to give interactivity to your query. This example will use a simple procedure of filtering a column to show how it works. Now filtering a column seems like overkill, but if you have a LOT of columns, scrolling across the many columns can be a hassle. Incorporating the parameter feature may make it less of a hassle.