Use previous full cell in the subsequent empty cells in a range

I have a single row range (row 1) where one cell will be filled followed by a number of empty cells, then another cell filled followed by another number of empty cells. How do I create a formula in a corresponding row below this range (row 2), where it will look up the range and fill in every cell with the value of the previous full cell's value in the range. Here is what it looks like;

colA|colB|colC|colD|colE|colF|colG|
1 12 |emp|emp|emp| 32 |emp|emp| (original data I have, where emp means empty cell)
2 12 | 12 | 12 | 12 | 32 | 32 | 32 | (this is the row that will be populated with the formula I am trying to create)

Hope it's clear.
Thank you

Try this

Highlight the ENTIRE Range
Press CTRL + G
Click Special
Select Blanks
Click OK
Press =
Press LEFT Arrow Key
Press CTRL + ENTER

Hope that helps.

Thank you very much for your response Jonmo1. Your solution works for populating the fields in an automated fashion, however, I was looking for a formula that I can plug in which would then calculate it. The ranges I defined here as an example are 8 column wide, while these ranges are more than 300 columns (ColA-ColD and ColE-ColG)for each of the 50+ data groups (12 and 32) in reality, which would make it more cumbersome and error-prone for the non-savvy users who would eventually use this sheet.

Thank you

What I was trying to say earlier was that selecting 4 cells and following the steps Jon has outlined is easy; while selecting 300 cells, following the steps and doing this repeatedly over 50+ times will more than likely introduce human error. And, mind you, there are a few other formulas already in place to get the final result and this step is the only one so far I could not create a formula for. Ultimately and ideally, I will have the formula look up the source sheet and do all the calculation without any manual work.

Thank you.

Why would you have to do it 50+ times?

The first step is to highlight the ENTIRE Range.