pull header into column

[MoLaw]

I have a worksheet with almost 600 individual tables formatted like so

HEADER
info, info, info
info, info, info
info, info, info

HEADER
info, info, info
info, info, info

HEADER
info, info, info
info, info, info

Basicly there is a blank row between every seperate table so to speak and I would like to pull the header out so it ends up like this

HEADER, info, info, info
HEADER, info, info, info
HEADER, info, info, info
HEADER, info, info, info

Any help would be apperciated

MoLaw

[snasui]

I have a worksheet with almost 600 individual tables formatted like so

HEADER
info, info, info
info, info, info
info, info, info

HEADER
info, info, info
info, info, info

HEADER
info, info, info
info, info, info

Basicly there is a blank row between every seperate table so to speak and I would like to pull the header out so it ends up like this

HEADER, info, info, info
HEADER, info, info, info
HEADER, info, info, info
HEADER, info, info, info

Any help would be apperciated

MoLaw

See attached picture:

A3
=IF(ISBLANK(D2),C2,0)

Enter

B3
=IF(ISBLANK(D3),"",LOOKUP(REPT("z",255),$A$3:A3))

Enter

Select A3:B3 and copy down.

[MoLaw]

Thanks, I believe that will help