Dynamically populate column that has values already in the column

[Dpsaint]

Hi I have a data set that looks like this

Search	ORGid	ID
AF01	BC8765	1765
	BC8765	4325
	BC8765	4567
DM02	BC8765	890
	BC8765	6545
	BC8765	8765
	BC8765	2541
	BC8765	0943
CAN03	BC8765	9871
	BC8765	4321
	BC8765	9876
	BC8765	3741

In the search column, there are populated cells that are the area. After each of these, there are bank cells until you reach the next area's data. Unfortunately, this is a limitation of how the data is extracted. 

I would like to know if it is possible to populate the empty cells with the Value from the areas as it goes down the list. The area will remain the same until the next Pre-populated value. It should look like this.

Search	ORGid	ID
AF01	BC8765	1765
AF01	BC8765	4325
AF01	BC8765	4567
DM02	BC8765	890
DM02	BC8765	6545
DM02	BC8765	8765
DM02	BC8765	2541
DM02	BC8765	0943
CAN03	BC8765	9871
CAN03	BC8765	4321
CAN03	BC8765	9876
CAN03	BC8765	3741

Any help or guidance around this would be much appreciated.

Thanks

[BS_THE_ANALYST · Accepted solution]

@Dpsaint I'd use the Multi-Row formula:

[Dpsaint]

That worked great!! Thank you for your help @BS_THE_ANALYST