I believe you are on to something with that, but there is one
discrepancy.

The "headings" I was referring to are actual data in cells, not the
cell address. For instance, the columns are patient numbers (1-250)
and the rows are patient data (text such as Cycle1). Sorry for the
confusion. In an ideal world, the 1st column on the new spreadsheet
would contain the patient number corresponding to the blank cell and
the second column would contain the patient data corresponding to the
blank cell .

Thanks!!!
Geoff