Thank you all for your responses - will give them all a try.

In answer to your question, the row information (where I am looking for non
blanks) is a numeric value and the column header I am after is text.

Thank you all very much for your time.