How do i copy section headings automatically in excel

[Guest]

I have a large list of data split into sections: A1:b1 contains
heading/description c1:d8 contains data. A10:b10 contains the next
heading/description with data in c10:d20 etc. I was hoping there was a
function in excel to automatically copy the headings beside the data.

 

[Guest]

Assuming each set of headers are separated by an equal number of lines in
between, viz headers are in A1:B1, then in A10:B10, then A19:B19, A29:B29,
etc (ie 9 lines in between headers)

Places in say, E1: =OFFSET(A$1,ROW()*9-9,)
Copy E1 to F1, then fill down until zeros appear, signalling exhaustion of
headers

 

[Guest]

If the cells below each set of headers are blank (here it doesn't matter if
the number of lines in between headers vary), think you could try this ..

Copy n paste cols A and B into a new sheet. In the new sheet, select cols A
and B. Press F5 > Special > Check "Blanks" > OK. This selects all the blank
cells in cols A and B. Then just right click on the selection > Delete >
Entire row > OK