Problem #2: Compare Data from Two Sheets and Extra the matching data with all the columns

1. Drag&Drop your Excel files into browser2. Choose from menu Merging tables -> Add Drag & Drop merging table3. Drag&Drop “ID” column from Sheet2 into the rules area (left side of the rule)4. Next Drag&Drop “ID” column from Sheet1 into the right side of the rule5. Export matched rows into XLSX/XLS

Columns from both sheets will be included in the export.

Problem #3: Find like numbers over two spreadsheets and highlight

1. Drag&Drop your Excel files into browser2. Choose from menu Merging tables -> Add Drag & Drop merging table3. Drag&Drop “column E” from Spreadsheet 1 into the rules area (left side of the rule)4. Next Drag&Drop “Column A” from Spreadsheet 2 into the right side of the rule5. Export matched rows into XLSX/XLS

Resulting spreadsheet will have 6+9 columns, and will contain row for each match between Column E of Spreadsheet 1 and Column A Spreadsheet 2.