Formula To Pull Through Headers For Each Section

Please see attached.

I am looking for a formula to copy down the header for each section.

A header is defined by having text in column C but no values in column D.

I then want these headers to be added in Column B for each section (example shows as red text)

Can anyone help?

Thanks

McCrimmon

PS - I could easily achieve this through vba by storing the headers etc, however, this NEEDS to be a formula.

For those that dont like looking at attachments.

An example of the data would be as follows:

COLUMN C would contain text
COLUMNS D, E, F & G would contain numbers

A header is distinguised by not having any data in columns D.

HEADER 1
DATA1, 100, 100, 100, 100
DATA2, 100, 100, 100, 100
DATA3, 100, 100, 100, 100
HEADER 2
DATA4, 100, 100, 100, 100
HEADER 3
DATA5, 100, 100, 100, 100
DATA6, 100, 100, 100, 100

I would like the output to look like this.

Header Category in Column B, Data Type in Column C and Data Numbers in Columns D, E, F & G.

So the above example looks like this:

HEADER 1, DATA1, 100, 100, 100, 100
HEADER 1, DATA2, 100, 100, 100, 100
HEADER 1, DATA3, 100, 100, 100, 100
HEADER 2, DATA4, 100, 100, 100, 100
HEADER 3, DATA5, 100, 100, 100, 100
HEADER 3, DATA6, 100, 100, 100, 100

Any suggestions?