Hi guys

I have imported data into excel, approximately 5000 records. Each record can occupy several lines. Column A is the persons name so consequently there are several blank cells under each name, and the number of blanks varies depending on the size of the individual record,

I wish to sort by column A and keep the records intact, the simple solution is to individually copy the name to each blank cell underneath it, but there are 5000 so it would take forever. Is there a formula I could use to, or would it be possible to use something like subtotal to do the sort?

Thanks in advance