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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"awolxx" wrote:
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.