Assume a simple matrix like data structure as shown below. As one can observe, for every unique ID, there are duplicate traits appearing. The objective is to remove duplicate traits from each row. The Expected solution is show in the second table.
| Unique ID | Trait1 | Trait2 | Trait3 | Trait4 | Trait5 |
| a | 1 | 1 | 2 | ||
| b | 1 | 2 | 1 | 3 | 3 |
| c | 2 | 2 | 1 | 3 | 4 |
| Unique ID | Trait 1 | Trait 2 | Trait 3 | Trait 4 | |
| a | 1 | 2 | |||
| b | 1 | 2 | 3 | ||
| c | 1 | 2 | 3 | 4 |
While there is a feature to remove duplicates from columns, there is no feature to do so from rows. You may download my workbook from here.
You may also watch a short video of my solution here
Remove duplicates from rows
{ 0 Comments }