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):
Existing Format of Data (note there are two empty lines between name and one empty line between next customer data):