I have a workbook where column 1 may have multiple duplicates, and some rows are filled for column 2,3,4 etc. Whenever column 1 is a duplicate, I need to duplicate the value shown in column 1 where that row is not duplicated. ex.:
| Column 1 | Column 2 | Column 3 |
|
ABC |
Alphabet | Gold |
| 1hn | Mixed | Silver |
| 470 | Numeric | Platinum |
| ABC | ||
| ABC |
Within this workbook, the two duplicates at the bottom need to pull in the same value that is in Column 2 and Column 3 in row 2 to show:
| Column 1 | Column 2 | Column 3 |
|
ABC |
Alphabet | Gold |
| 1hn | Mixed | Silver |
| 470 | Numeric | Platinum |
| ABC | Alphabet |
Gold |
| ABC | Alphabet | Gold |
There are many other columns that must not be touched (may be different between the three rows). What is my best route towards duplicating these values here with minimal waste?