Two inconsistent date ranges

[Inzy]

Hi. I have two tables, each with two columns.

In both cases the first column is a date and the second one is a number, however, the two date lists are inconsistent - some dates are missing from each, so sometimes table a has a date and b doesn't, and sometimes vice-versa.

e.g.

1 jan / 0.1 / 1 jan / 0.9
2 jan / 0.5 / 4 jan / 0.4
3 jan / 0.2 / 5 jan / 0.7
4 jan / 0.2 / 6 jan / 0.2

I want to be able to align the two tables so that where there is no date in one I insert a row to bring it into alignment with the correct date (in the example above inserting two spaces above 4 jan in the third and fourth columns). Ultimately I am going to delete all the rows where there is only one date as well.

Does anyone know a quick way to do this? At the moment I am checking it by eye and deleting them one by one, but I have >1000 rows ...

[Glenn Kennedy]

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

However, nothing on this Forum works quite as well as you might expect. The attachment icon doesn't work!! (Helpful, isn't it!!). Instead, just before you submit your post, click on GO ADVANCED (near the bottom) and then scroll down to Manage Attachments to open the upload window. The relevant instructions are at the top of that screen.