fbpx
Search
Close this search box.

All articles with 'combine files' Tag

Combine multiple Excel files using Power Query [Full example + download]

Published on May 30, 2019 in Power Query
Combine multiple Excel files using Power Query [Full example + download]

Say you want to combine multiple Excel files, but there is a twist. Each file has few tabs (worksheets) and you want to combine like for like, ie , all Sheet1s to one dataset, all Sheet2s to another dataset…

To make matters interesting each sheet has a different format.

What now?

Of course Power Query to the rescue.

Continue »