Bono Vacantia

While the Scottish equivalent can be downloaded as an ExCel file, the English Bono Vacantia is a little more awkward. I like to work on one week's legacies at a time, so I select only details published on a single Thursday. typically there will be about 15 to 30. These are presented as pages of 15 'deceaseds'.
I highlight the 4 columns of details, including the column headings, and copy and paste them to a new ExCel worksheet, or a new page in an existing worksheet. There will be two rows for each deceased, but I will explain that later. I then go to the next page, highlight the entries, this time excluding the column headings, and paste them into the worksheet immediately below the first 15 entries, and repeat this until I have all the entries on my spreadsheet page.
I select the first column, right click, and 'remove hyperlinks'. I add a column to the right of the first column containing surnames and forenames.
I select the entire first column, omitting only the row titles and the first surname, and copy it to the new 2nd column, but one row higher. This places the forenames in a separate column to the right of the associated surnames.
I select all cells, go to Format Cells, and remove 'Merge Cells' and 'Wrap Text'.
I sort the entire page on column 4, the date of death column. This will force the unwanted rows containing only forename and unrelated surname to the bottom, where they can easily be emptied or deleted.
It only remains to adjust the Format to autofit cell width and height.
At this point I save the spreadsheet, using a name such as yyyymmdd bono vacantia.xlsx.