Merging tables and worksheets

You can merge two or more tables or worksheets to combine their rows together into a single, larger worksheet.

Merging two or more tables or worksheets combines their rows together into a single, larger worksheet. The rows from the foreign table(s) are appended to the end of the base table in the order in which they are specified. The results apply only to your session; the original tables or worksheets are not affected. The resulting table may contain all columns in either table, all common columns, or only a subset of the common columns.

Note: Merging differs from linking. Merging combines the rows of two or more tables or worksheets together whereas linking combines the columns of two tables or worksheets together. Links align worksheets side by side, while merges combine worksheets vertically.