Merge Tables - Spreadspeed Help | BreezeTree
BreezeTree Home Spreadspeed Product Page
Spreadspeed Help Introduction
Range Selector
 Navigation Tools
File Operations
Quick Navigation Buttons
 Workbook Tools
Create Table of Contents
Sort Sheet Tabs
Add Multiple Worksheets
Remove Empty Worksheets
Quick Hide / Unhide Sheets
Save Worksheets to Separate Files
Close and Re-Open Last Save
Save a Backup Copy of Workbook
Quick Protect
Quick Unprotect
Hide / Unhide Named Ranges
 Worksheet Tools
Delete Blank Rows
Delete Blank Columns
Autofit Rows and Columns
Reset Used Range
 Range Tools
Split Single Column into Multiple Columns
Split Single Row into Multiple Rows
Concatenate Columns
Concatenate Rows
Transpose in Place
Swap Ranges
 Table Tools
Filtering Records
Join Tables
Merge Tables
Find Unmatched Rows
Extract Columns
Extract Filtered Data
Extract Duplicate Data
Remove Hidden Rows
 Shapes Tools
Select Shapes by Type
Group All
Ungroup All
Extract Text
 Trim Text
Advanced Trim Tool
Trim Selection
Clean Text
Clear Empty Strings
 Change Case
Change Case Tool
Change Case on Selection
Change Name Case
Prefix / Suffix
 Number Operations
Fill Range with Random Numbers
Perform Math Operations in Place
Negate Selected Values
Remove Non-Numeric Characters
Convert Text to Number
Convert Formulas to Values
Round to X Decimals
 Date Operations
Fill Range with Random Dates
Convert Text to Date
Change Date Formats
Date Formats
 Data Operations
Sum and Percentages
Descriptive Statistics
Remove Repeating Data
Fill Repeating Data
Perform Random Sort
Create Validation Dropdown List
 Export Operations
Save Chart to Image File
Save Range to Image File
Save Shapes to Image File
Save Range to Text File
Create HTML Unordered List
Create HTML Ordered List
Create HTML Table
 Format Operations
Reset All Cell Styles
Delete Unused Custom Cell Styles
Selectively Clear Formats
Clear Excess Formatting
Merged to Center Across
Dependency Navigator (Auditor)
Visual Audit (Auditor)
 Audit Reports (Auditor)
Worksheet Comparison Report
Master Audit Report
Cell Errors Report
Circular References Report
Comments Report
External References Report
Hyperlinks Report
Formulas Report
Named Ranges Report
 Inconsistent Formulas (Auditor)
Find Inconsistent Formulas
Flag Inconsistent Formulas
Compare Worksheets (Auditor)
 Hyperlinks Audit (Auditor)
Open Hyperlinks Navigator
Remove Hyperlinks
Convert Hyperlink Formulas
 Comments Audit (Auditor)
Delete All Comments
Remove User Name
Restore Formats
Spreadspeed Support
Log Files
Uninstalling Spreadspeed
How to Buy

Merge Tables

The Merge Tables tool lets you update one table from another. New rows in the update source table can be appended to the end of the main table.


Form Fields


Table Selection Step

Table 1: Select the workbook, worksheet, and range where Table 1 is located. The "tables" do not have to be Excel tables - any range will work.
Table 2: Select the workbook, worksheet, and range where Table 1 is located.


Matching Columns Step

Select Matching Columns: In the second step of the Join Tables dialog, you select the columns to match on between table 1 and table 2.
Ignore case for matching columns: If checked, the text casing is ignored when comparing the fields in matching columns.


Set Options Step


Merge Options - you must select at least one of these options to run Merge Tables:

Merge Table 2 into Table 1: Updates Table 1 with values, formulas and number formats from Table 2.
Append new Table 2 rows to Table 1: Adds new rows from table 2 onto the end of  table 1.
Mark Table 1 rows unmatched in Table 2: If table 1 has rows that don't exist in Table 2, these can be marked with a selected fill color.


Note on fill colors: If you do not want the updated cells highlighted with a fill color, set the fill to white.


Comparison Options

Skip Table 1 cells with formulas: This ensures that existing formulas do not get overwritten.
Ignore text case when comparing strings: If checked, string capitalization is ignore when checking for updates.
Ignore blank cells in Table 2: Ensures that checks with content do not get overwritten with blanks.
Compare number and date formats: If checked, table 1 will be updated with changes to table 2 number and date formatting.


Reporting Options:

Add a Change Notes column: Adds a column to table 1 describing each row's updates.



Save time-stamped backup: saves a backup of the Table 1 workbook before applying the updates.




©2014 BreezeTree Software, LLC. All Rights Reserved.