instal the new version for android Ablebits Ultimate Suite for Excel 2024.1.3443.1616

You can paste additional matching rows at the end of the table or after the row with the same value in the key column. Select this option to add rows with duplicate key values that may contain unique information in other columns. When you choose Add non-matching rows to the end of the main table, the rows with such values will be inserted after all rows in the appropriate columns of the main table: So, the IDs from 16 to 20 in your lookup table are non-matching. The lookup table contains IDs from 1 to 20. Non-matching are the rows with the key values that are not present in your main worksheet.įor example, you match tables by the column with IDs. Add non-matching rows to the end of the main table.All these options are applied to the main table: The last step offers advanced options that let you fine-tune the merge. Step 6: Choose additional merging options

Select or deselect all columns at once by using the buttons Select All and Unselect All respectively. Pressing Unselect All will remove selection from all columns.If you ticked the Main table has headers and/or Lookup table has headers checkboxes, only columns with corresponding headers will be selected. Click Auto Select to get all the columns selected as matching.

This will instruct the Merge Tables Wizard to distinguish between uppercase and lowercase letters in the values it compares.

If text case in the key columns is important to you, tick off the Case-sensitive matching checkbox at the top.

In this case, the contents of the 1st row will be displayed to help you match the right records. If your tables do not have headers, clear these boxes.

If your tables have header rows, select the Main table has headers and/or Lookup table has headers checkboxes.

If there is no match, please select one in the drop-down list of Lookup table columns. Once chosen, the add-in will automatically pick a column with a matching header in a lookup table if there is one. Tick the checkboxes next to the columns you need to compare. Here you can see a table with a list of all the columns you have in your main sheet. Please note that the values in these columns are only compared you will be able to select the columns to update on the next step. Key columns are the important ones that let you identify the same records in your sheets, for example, IDs or the combination of First and Last names. Your tables may have several columns in common. You can edit the range by clicking the Select range icon or simply using your mouse cursor to select it in your table.

Instal the new version for android Ablebits Ultimate Suite for Excel 2024.1.3443.1616