Append sheets
Append tables and keep one copy of identical rows
Combine files and keep one copy of each identical row. Records with different amounts or other values stay in the result.
Append sheets
Match customer lists, find missing values, and combine spreadsheets. See how to solve everyday Excel problems with worked examples in JOIN SHEET.
Append sheets
Keep rows when either of two columns matches
Keep rows where either name starts with N. Filter each name column separately, then combine the saved results without counting shared matches twice.
Append sheets
Find repeated IDs across files and keep their full records
Find IDs that appear more than once across combined files, then join the ID list back to keep every matching record.
Append sheets
Why do duplicate-looking rows remain after I hide a column?
Duplicate removal checks every source column, even hidden ones. Show hidden fields to find why two rows that look identical both remain.
Append sheets
Append only the detail worksheets from a workbook
Combine a workbook’s monthly detail sheets without counting the summary twice. Exclude unwanted sheets before appending.
Append sheets
Combine code lists without repeating codes with different descriptions
Prepare code-only inputs and append them with duplicate removal to get one row per code, regardless of description differences.