Example of stacking worksheets into a new worksheet

An analyst wants to combine information from two locations into one worksheet.

Create and save the following worksheets:

Plant_1.MTW

C1-T C2

Operator Parts

Jorge 22

Melanie 24

Lucia 17

Chris 15

Plant_2.MTW

C1-T C2

Operator Parts

Belinda 24

Don 27

Phyllis 28
Choose Data > Stack Worksheets.
From Stack option, select Stack worksheets in a new worksheet.
Use the arrow key to move Plant_1.MTW and Plant_2.MTW from Available worksheets to Worksheets to stack.
In New worksheet name, enter Company_wide.
Click OK.

Results

In the stacked worksheet, the columns that have the same names are stacked and the source worksheet for each row is identified in the Source column.