I've got a list of imported broken links. I need to sort the list based on column C (the error code) so I can find all links with error 404. However, I need to know the corresponding parent page (column A) for all the links. The problem is that the parent page in column A is only listed once before all its corresponding links are listed below it in column B.
I assume I need to somehow copy down the values in column A until you reach the next URL, and then copy that down and so fourth for all of column A. Is there a way I can do this fairly easily? It's a huge spreadsheet so manually is out of the question.
Below is a screenshot of part of the spreadsheet: