Combine two sets of data, merging the values from a worksheet or previously named table. This is generally used with two similar data sets, totalling the numbers, retaining the most recent date, and/or preserving a list of category values.
Combine With – Select a worksheet or previously saved table from the drop down list. The worksheet must be in the same workbook, and data must start in cell A1 with a header row. If you want to use a table in memory, use Table Name to create the reference.
Align Data – align the rows between the two tables by the values in selected columns or by the row numbers.
Select Key Columns – choose which columns to use to align the data between the tables. Optionally ignore case and/or ignore spaces when doing the comparison.
Aggregation
Text/Number/Date Columns – where both tables have matching values in the key columns, the remaining columns are combined using the selected options for text, number and date columns. The text option ‘All (list)’ will produce a comma-separated list of values in each cell.
Options
Add new rows – automatically add rows that are only in the referenced table.
Add new columns – automatically add columns that are only in the referenced table.
Blog article: Using the Combine Function