Repeat combined cell value only until new value is seen or reached

[MrDeals]

Hi,

I would like to bring over the data from Column C into Column A.
Only the IF the cell matches to be a SKU:
I want to to drag down the formula and excel should copy in the SKU, UNTIL it reaches the next matching SKU and then continue

Using the following, only gives me corresponding row, but leaves the non-matching rows empty
=IF(B2="SKU:",C2,"")


Thank You

 

[Fluff]

How about

=IF(B2="SKU:",C2,B1)

 

[MrDeals]

How about

=IF(B2="SKU:",C2,B1)

Thanks, but it doesn't work

Here's how Column A looks with this
A1 SKU:
A2 GHR-954
A3 SKU:
A4 GHR-923
A5 SKU:
A6 60280
A7 60313

 

[Fluff]

Oops, it should be A1 at the end not B1

 

[MrDeals]

Oops, it should be A1 at the end not B1

Yea!!!
=IF(B2="SKU:",C2,A1) WORKS

Thank you so much for a quick response

 

[Fluff]

You're welcome & thanks for the feedback.