Copy Tables to Master Table

Copy Excel tables into new master table

This project shows how to combine data that resides in Excel tables into a new master table with all rows included. It creates a new worksheet and combines all rows into a single table.

There are two variations of this script

1. First script combines all tables in the Excel file. It assumes that all tables in the Excel files have same structure.
2. Second script that selectively gets tables within a set of worksheets. It assumes that all the tables in those select worksheets have the same structure.

Video link

Office Scripts

Checkout the directory.

1. Copy all tables in Excel to a new master table
2. Copy tables from select worksheets into a new master table

Excel files used

1. Copy all tables
2. Copy select tables