In order to simplify this question, I have put column headings in "quotation marks".
I am working on geological borehole log data, with "depth" in column C, a set group of "geological units" being repeated down column D, and "sequences" based on specific depositional times and environments...