Hi All,
I have the below sample data set where I'd like to fill out the Vendor Name if the ID/name exists already. Any idea how I can do this? The IDs are not always in order and sometimes there is no ID to fill in Vendor Name and thats OK. If thats the case, it can remain as NULL.
Current:
| VendorID | VendorName | Date |
| 1 | SMITH | 1/1/2022 |
| 2 | JOHN | 2/1/2022 |
| 3 | MICKEY | 3/1/2022 |
| 2 | NULL | 4/1/2022 |
| 3 | NULL | 5/1/2022 |
| 1 | NULL | 6/1/2022 |
| 4 | NULL | 7/1/2022 |
| 5 | NULL | 8/1/2022 |
Expected:
| VendorID | VendorName | Date |
| 1 | SMITH | 1/1/2022 |
| 2 | JOHN | 2/1/2022 |
| 3 | MICKEY | 3/1/2022 |
| 2 | JOHN | 4/1/2022 |
| 3 | MICKEY | 5/1/2022 |
| 1 | SMITH | 6/1/2022 |
| 4 | NULL | 7/1/2022 |
| 5 | NULL | 8/1/2022 |
