Hello, I have hundreds-of-thousands of rows, which most of them have missing values (column 2). Based on a primary key (column 1), I can assume that the missing values can be imputed with values associated with that key. An example would be necessary.
<tbody>
</tbody>
All orders "123" date are "02/02/2017". All orders "1234" date are "02/03/2017", etc..
Using or not using index match, how can I fill in all of the missing fields of the 2nd column in the 3rd column?
Any help would be greatly appreciated. Thank you.
| Primary Key | Date | Date.Impute |
| 123 | "" | |
| 123 | "" | |
| 123 | 02/02/2017 | |
| 1234 | "" | |
| 1234 | 02/03/2017 | |
| 1234 | "" | |
| 12345 | 01/01/2017 | |
| 12345 | "" |
<tbody>
</tbody>
All orders "123" date are "02/02/2017". All orders "1234" date are "02/03/2017", etc..
Using or not using index match, how can I fill in all of the missing fields of the 2nd column in the 3rd column?
Any help would be greatly appreciated. Thank you.
Last edited:
