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.