Excel veterans: Can a file like this be sorted?

[Anmorphic]

Hello everyone, I've got an Excel spreadsheet which has customer data from an older program in a "report" style. I wish to sort the spreadsheet by separating the customer data into separate columns, however the format the spreadsheet is in is very, umm, difficult. I need to figure out how to write a sorting algorithm to sort this data. Below I show the format it's in, and the format I would like it to be sorted into. Thank you in advance, any help or tips would be fantastic!

Existing Format of Data (note there are two empty lines between name and one empty line between next customer data):

 

[PA HS Teacher]

I've just read your thread quickly, so I think this is relevant.

In general if you have functions that return a value, and you would like to keep those values, simply copy the cells, then paste special as values.

 

[Anmorphic]

PA HS Teacher thank you, I was able to successfully perform these actions.

My sincerest appreciation.