Monday, January 30, 2023

Combine & Unpivot Tables Multiple Excel Files in Folder

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.

No comments:

Post a Comment