Overview for Merge Worksheets

Use Merge Worksheets to combine two or more open worksheets into one new worksheet. There are two ways to merge worksheets: side-by-side or match values. Stored constants, matrices, DOE objects, formulas, and worksheet descriptions are not transferred into the merged worksheet.

Side-by-side

Merge multiple worksheets by placing all columns side-by-side in a new worksheet. For example, one nurse records patient heights and weights in a worksheet, and a different nurse records patient gender and activity in a different worksheet. An administrator merges the two worksheets side-by-side.

Worksheet 1

C1 C2
Height Weight
66.00 140
61.00 140
73.50 160
63.00 121

Worksheet 2

C1-T C2-T
Gender Activity Level
M A lot
F Moderate
M Slight
F a lot

Merged worksheet

C1-T C2-T C3 C4
Gender Activity Level Height Weight
M A lot 66.00 140
F Moderate 61.00 140
M Slight 73.50 160
F a lot 63.00 121

Match values

If you have variables that use the same set of units (for example, locations or sales data) in two different worksheets, use Match Values to combine the information into a single worksheet so that each row contains information for the same unit.

For example, a sales manager can merge worksheets that contain monthly sales data from two stores.

Store 1

C1 C2
Month Sales
January 23
February 24
March 29
April 30

Store 2

C1 C2
Month Sales
February 12
March 10
April 14
May 15

Merged worksheet

The month values from each worksheet are in the same rows.
C1 -D C2 C2 -D C3
Month:Store1.MTW Sales:Store 1.MTW Month:Store 2.MTW Sales:Store 2.MTW
January 23 * *
February 24 February 12
March 29 March 10
April 30 April 14
* * May 15

Where to find this command

To merge worksheets, choose one of the following:
  • Data > Merge Worksheets > Match Values
  • Data > Merge Worksheets > Side-by-Side

When to use an alternate command

If you want to stack corresponding columns from multiple worksheets, using Stack Worksheets might be easier.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy