Need excel file re-organized for use in print

I have an Excel spreadsheet that needs to be re-organized. It is pretty large (5419 rows), but with a simple structure. There needs to be a row inserted above each unique category (column A), the contents of cell (in column A) below the newly created row needs to be copied into the new row's cell in column A. Then, the remaining (non-unique) cell contents of column A need to be deleted. The same then needs to be done with the sub-categories (column B). Then the islands (column C). Then columns A, B, C and D need to be combined into one column. I also need a column inserted to the left of column A, with squares in the cells next to ballot items (originally in column D). In the end, they will be used in a printed ballot (sample [login to view URL] attached). I have created a second tab in the workbook [login to view URL] and manually done this for the first group to show you how it should look. I could do this manually myself, but am looking for someone that can automate the process. I would also like to know how it is done.