Fill in NULL values with other data in set

[mystasz]

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

[ChrisTX]

Can you paste your sample data as text?

[IraWatt]

Hey @mystasz,

Heres one way you can try out:

Any questions or issues please ask :)
HTH!
Ira

[mystasz]

Thanks! I updated my dataset to display that each row has a different date. 

[mystasz]

Updated 

[IraWatt · Accepted solution]

Hey @mystasz,

Here's an example with your dataset: