Thanks for replying - Sorry, data I'm working with is person identifiable so can't attach it.

Basically I've got approx 4000 rows of dates of service contacts with patients and each
date has an identifier next to it - I've got approx 500 individuals in the data. What I
want in the results is a row of dates per patient so that I'll only have approx 500
unique rows with identifiers in column A and dates starting in column B and stretching
across columns as far as they need to for each individual.

Which is why I mocked up this really simole version of my data to share with you .....
Thought it might help!