Help reformatting a badly constructed table

[StuartR]

This redacted document contains data that I need to be able to sort, search, and delete specific dates from. (The original document has many more rows, but this should be enough to show the problem).

Unfortunately the formatting is really unhelpful, with multiple dates per table row, and use of new lines to align the date with the content.

Any suggestions on the easiest way to reformat this so there is one date per table row.

[HansV]

I selected the table, copied it and pasted it into an Excel worksheet.
I selected column A, pressed F5 to activate the Go To dialog, clicked Special..
I selected Blanks, then clicked OK.
I right-clicked one of the selected cells, selected Delete, then Shift cells up... and clicked OK.
I repeated this for column B. There was one empty-looking cell that contained a space, I deleted that manually.
I selected the resulting range and cleared all formatting, to get rid of borders.
I turned on Wrap Text for column B and adjusted the column widths and row heights.
Finally, I copied the table and pasted it back into Word.
It may need some additional tweaking such as top alignment.
This is the result:

Redacted document Modified.docx

[StuartR]

That is very good Hans, I will try it on the full document and let you know how well it works.

[StuartR]

That worked brilliantly, and while it was in Excel I also tidied up all the dates by getting rid of st, rd, nd etc and formatting consistently

[HansV]

Great!