Wednesday, April 24, 2019

Combine Tables from Multiple Sheets in the Same Workbook with Power Query

If you work with data in many worksheets, sometimes it's better to combine this all into one worksheet. Especially if they all have the same header fields. You can usually do a copy and paste, but if there are a lot of worksheet or if this is a recurring task, you might want to semi automate it. Power Query makes this easier to do. This video shows how to combine tables from different tabs in the same file using the Append capability in the Excel with Power Query.


1 comment:

  1. Where's the sample data file for "Combine Tables from Multiple Sheets in the Same Workbook with Power Query"?
    Thanks

    ReplyDelete