Consolidating excel entries
A bunch of values in one of the columns are essentially the same while data in other columns are different.
The screenshot below illustrates what we are trying to achieve.
The add-in works with all versions of Excel 2016, 2013, 20.
The task: you have some Excel database with a few thousand entries.
There is a quicker way to achieve the needed result: Task: you need to merge rows from 2 tables based on a common column.
The tables may be located in the same sheet, in two different spreadsheets or even in two different workbooks.