Spreadsheet: 75887d1276505495-remove-unwanted-data-quest
Sheet: Sheet1

Date | Open | High | Low | Close |  |  |  | Date | Open | High | Low | Close
1994-01-03 00:00:00 | 1.478 | 1.485 | 1.4744 | 1.4752 |  |  |  | 1994-01-03 00:00:00 | 188.1 | 195.45 | 187.13 | 192.73
1994-01-04 00:00:00 | 1.4754 | 1.4877 | 1.474 | 1.4858 |  |  |  | 1994-01-04 00:00:00 | 193.73 | 195.06 | 191.94 | 192.99
1994-01-05 00:00:00 | 1.4858 | 1.4906 | 1.481 | 1.486 |  |  |  | 1994-01-05 00:00:00 | 193.48 | 195.21 | 188.71 | 191.42
1994-01-06 00:00:00 | 1.4864 | 1.4902 | 1.479 | 1.4812 |  |  |  | 1994-01-06 00:00:00 | 191.61 | 193.47 | 185.3 | 185.58
1994-01-07 00:00:00 | 1.481 | 1.496 | 1.48 | 1.493 |  |  |  | 1994-01-07 00:00:00 | 181.96 | 183.62 | 177.15 | 179.82
1994-01-10 00:00:00 | 1.492 | 1.4985 | 1.4905 | 1.4935 |  |  |  | 1994-01-10 00:00:00 | 180.78 | 181.25 | 169.42 | 171.03
1994-01-11 00:00:00 | 1.4926 | 1.496 | 1.4867 | 1.4905 | this date missed in the 2nd table------> |  |  | 1994-01-12 00:00:00 | 170.34 | 170.81 | 167.12 | 167.87
1994-01-12 00:00:00 | 1.4895 | 1.5065 | 1.4895 | 1.503 |  |  |  | 1994-01-13 00:00:00 | 169.06 | 172.15 | 168.7 | 170.24
1994-01-13 00:00:00 | 1.5035 | 1.507 | 1.4923 | 1.4963 |  |  |  | 1994-01-14 00:00:00 | 168.43 | 170.18 | 167.62 | 169.14
1994-01-14 00:00:00 | 1.4953 | 1.4991 | 1.4872 | 1.4928 |  |  |  | 1994-01-17 00:00:00 | 169.43 | 173.54 | 168.45 | 172.85
1994-01-17 00:00:00 | 1.4882 | 1.495 | 1.487 | 1.4945 |  |  |  | 1994-01-18 00:00:00 | 172.81 | 174.44 | 170.08 | 173.38
1994-01-18 00:00:00 | 1.4935 | 1.4992 | 1.4925 | 1.4957 |  |  |  | 1994-01-19 00:00:00 | 174.55 | 175.6 | 171.56 | 172.85
1994-01-19 00:00:00 | 1.4943 | 1.5022 | 1.489 | 1.4927 |  |  |  | 1994-01-20 00:00:00 | 172.9 | 173.84 | 170.63 | 173.14
1994-01-20 00:00:00 | 1.4917 | 1.5025 | 1.4875 | 1.497 |  |  |  | 1994-01-21 00:00:00 | 175.04 | 177.74 | 171.3 | 171.7
1994-01-21 00:00:00 | 1.4965 | 1.504 | 1.4905 | 1.4923 | <---- this date missed in the 1st table |  |  | 1994-01-24 00:00:00 | 169.78 | 174.67 | 168.79 | 174.36
1994-01-25 00:00:00 | 1.4935 | 1.4965 | 1.4915 | 1.4957 |  |  |  | 1994-01-25 00:00:00 | 174.63 | 176.66 | 173.79 | 175.02
1994-01-26 00:00:00 | 1.495 | 1.498 | 1.4911 | 1.4952 |  |  |  | 1994-01-26 00:00:00 | 174.68 | 175.57 | 172.11 | 173.63
1994-01-27 00:00:00 | 1.4945 | 1.512 | 1.4909 | 1.508 |  |  |  | 1994-01-27 00:00:00 | 172.6 | 172.75 | 169.84 | 170.56
1994-01-28 00:00:00 | 1.507 | 1.5096 | 1.494 | 1.4954 |  |  |  | 1994-01-28 00:00:00 | 170.92 | 172.26 | 169.55 | 170.12
1994-01-31 00:00:00 | 1.493 | 1.5083 | 1.493 | 1.5074 |  |  |  | 1994-01-31 00:00:00 | 170.02 | 170.39 | 166.34 | 167.34
1994-02-01 00:00:00 | 1.5064 | 1.5097 | 1.4975 | 1.5013 |  |  |  | 1994-02-01 00:00:00 | 166.79 | 167.5 | 162.58 | 162.74
1994-02-02 00:00:00 | 1.5006 | 1.502 | 1.4924 | 1.4943 |  |  |  | 1994-02-02 00:00:00 | 162.64 | 163.96 | 159.8 | 162.11
1994-02-03 00:00:00 | 1.4937 | 1.5013 | 1.4825 | 1.4867 |  |  |  | 1994-02-03 00:00:00 | 160.46 | 164.26 | 159.31 | 164.26
1994-02-04 00:00:00 | 1.486 | 1.4997 | 1.472 | 1.4769 |  |  |  | 1994-02-04 00:00:00 | 164.46 | 166.07 | 156.57 | 156.76
1994-02-07 00:00:00 | 1.474 | 1.485 | 1.474 | 1.4843 |  |  |  | 1994-02-07 00:00:00 | 156.33 | 164.21 | 156.08 | 163.51
1994-02-08 00:00:00 | 1.4834 | 1.4885 | 1.4648 | 1.4672 |  |  |  | 1994-02-08 00:00:00 | 164.38 | 165.04 | 160.47 | 162.6
1994-02-09 00:00:00 | 1.4667 | 1.472 | 1.457 | 1.4605 |  |  |  | 1994-02-09 00:00:00 | 162.82 | 163.27 | 159.24 | 159.7
1994-02-10 00:00:00 | 1.4605 | 1.465 | 1.454 | 1.4633 |  |  |  | 1994-02-10 00:00:00 | 160.28 | 165.13 | 159.13 | 160.16
1994-02-11 00:00:00 | 1.4626 | 1.469 | 1.458 | 1.4625 |  |  |  | 1994-02-11 00:00:00 | 160.08 | 160.57 | 154.13 | 156.01
1994-02-14 00:00:00 | 1.464 | 1.494 | 1.4625 | 1.4846 |  |  |  | 1994-02-14 00:00:00 | 154.84 | 157.9 | 154.63 | 156.58
I need to delete the green cells from both tables and then merge the yellow cells