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 .
- 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.
Company_wide.MTW
C1-T |
C2 |
C3-T |
Operator |
Parts |
Source |
Jorge |
22 |
Plant_1.MTW |
Melanie |
24 |
Plant_1.MTW |
Lucia |
17 |
Plant_1.MTW |
Chris |
15 |
Plant_1.MTW |
Belinda |
24 |
Plant_2.MTW |
Don |
27 |
Plant_2.MTW |
Phyllis |
28 |
Plant_2.MTW |