I have a worksheet with several 000's rows of data, holding information about patients' visits. Each row holds the information of a single visit.
Each patient can have multiple visits (i.e. appear in multiple rows). The table is sorted by patient name, and the left-most column holds the patient...