Spreadsheet: 113031d1308957533-combining-two-time-series-data-combinedatevolumes
Sheet: Sheet1

 | series1 |  |  |  |  | series2
Date | vol (x1) | vol(x2) | ratio |  | trans_date | vol (y1) | vol(y2) | ratio |  | First you need a list of [NAME] from Both Tables |  |  |  |  |  | Then use the formulas in this table to copy data over.
2003-07-01 00:00:00 | 2 | 2 | 0.5 |  | 2006-01-02 00:00:00 | 166365 | 159194 | 0.511013364705015 |  | Copy and Paste both date sets below each other Like:
2003-07-02 00:00:00 | 10700 | 700 | 0.9385964912280702 |  | 2006-01-03 00:00:00 | 559241 | 537436 | 0.5099413956889768 |  |  |  |  |  |  |  | Unique dates | x1 | x2 | y1 | y2
2003-07-03 00:00:00 | 5500 | 5500 | 0.5 |  | 2006-01-04 00:00:00 | 702076 | 717152 | 0.494688661723134 |  | 2003-07-01 00:00:00 |  |  |  |  |  | 2003-07-01 00:00:00 | 2 | 2
2003-07-07 00:00:00 | 0 | 3200 | 0 |  | 2006-01-05 00:00:00 | 511256 | 646572 | 0.4415647229122115 |  | 2003-07-02 00:00:00 | Then you need to get [NAME] dates so |  |  |  |  | 2003-07-02 00:00:00 | 10700 | 700
2003-07-08 00:00:00 | 850 | 200 | 0.8095238095238095 |  | 2006-01-09 00:00:00 | 577698 | 554481 | 0.5102532373414451 |  | 2003-07-03 00:00:00 | each date only shows once. |  |  |  |  | 2003-07-03 00:00:00 | 5500 | 5500
2003-07-09 00:00:00 | 212 | 12 | 0.9464285714285714 |  | 2006-01-10 00:00:00 | 792016 | 762056 | 0.5096391930361013 |  | 2003-07-07 00:00:00 | To do that in 2003 excel you need to |  |  |  |  | 2003-07-07 00:00:00 | 0 | 3200
2003-07-10 00:00:00 | 200 | 1000 | 0.1666666666666667 |  | 2006-01-11 00:00:00 | 302774 | 288311 | 0.5122342810255717 |  | 2003-07-08 00:00:00 | Do an Advanced Filter [NAME]. |  | >>> |  |  | 2003-07-08 00:00:00 | 850 | 200
2003-07-11 00:00:00 | 0 | 1021 | 0 |  | 2006-01-12 00:00:00 | 297663 | 301434 | 0.4968527634089304 |  | 2003-07-09 00:00:00 |  |  |  |  |  | 2003-07-09 00:00:00 | 212 | 12
2003-07-14 00:00:00 | 21 | 1200 | 0.0171990171990172 |  | 2006-01-13 00:00:00 | 648913 | 587279 | 0.5249289754342368 |  | 2003-07-10 00:00:00 |  |  |  |  |  | 2003-07-10 00:00:00 | 200 | 1000
2003-07-15 00:00:00 | 21 | 11121 | 0.001884760366182014 |  | 2006-01-16 00:00:00 | 291164 | 310344 | 0.4840567374000013 |  | 2003-07-11 00:00:00 |  |  |  |  |  | 2003-07-11 00:00:00 | 0 | 1021
2003-07-16 00:00:00 | 41 | 21 | 0.6612903225806451 |  | 2006-01-17 00:00:00 | 896804 | 844802 | 0.5149293238539601 |  | 2003-07-14 00:00:00 |  |  |  |  |  | 2003-07-14 00:00:00 | 21 | 1200
2003-07-17 00:00:00 | 100 | 100 | 0.5 |  | 2006-01-18 00:00:00 | 1420572 | 1463816 | 0.4925037824314898 |  | 2003-07-15 00:00:00 |  |  |  |  |  | 2003-07-15 00:00:00 | 21 | 11121
2003-07-18 00:00:00 | 50 | 4 | 0.9259259259259259 |  | 2006-01-19 00:00:00 | 845261 | 698515 | 0.5475282683498124 |  | 2003-07-16 00:00:00 |  |  |  |  |  | 2003-07-16 00:00:00 | 41 | 21
 |  |  |  |  | 2006-01-20 00:00:00 | 686578 | 707851 | 0.4923721465919025 |  | 2003-07-17 00:00:00 |  |  |  |  |  | 2003-07-17 00:00:00 | 100 | 100
 |  |  |  |  | 2006-01-23 00:00:00 | 473282 | 444938 | 0.5154342096665288 |  | 2003-07-18 00:00:00 |  |  |  |  |  | 2003-07-18 00:00:00 | 50 | 4
 |  |  |  |  |  |  |  |  |  | 2006-01-02 00:00:00 |  |  |  |  |  | 2006-01-02 00:00:00 |  |  | 166365 | 159194
 |  |  |  |  |  |  |  |  |  | 2006-01-03 00:00:00 |  |  |  |  |  | 2006-01-03 00:00:00 |  |  | 559241 | 537436
 |  |  |  |  |  |  |  |  |  | 2006-01-04 00:00:00 |  |  |  |  |  | 2006-01-04 00:00:00 |  |  | 702076 | 717152
 |  |  |  |  |  |  |  |  |  | 2006-01-05 00:00:00 |  |  |  |  |  | 2006-01-05 00:00:00 |  |  | 511256 | 646572
 |  |  |  |  |  |  |  |  |  | 2006-01-09 00:00:00 |  |  |  |  |  | 2006-01-09 00:00:00 |  |  | 577698 | 554481
 |  |  |  |  |  |  |  |  |  | 2006-01-10 00:00:00 |  |  |  |  |  | 2006-01-10 00:00:00 |  |  | 792016 | 762056
 |  |  |  |  |  |  |  |  |  | 2006-01-11 00:00:00 |  |  |  |  |  | 2006-01-11 00:00:00 |  |  | 302774 | 288311
 |  |  |  |  |  |  |  |  |  | 2006-01-12 00:00:00 |  |  |  |  |  | 2006-01-12 00:00:00 |  |  | 297663 | 301434
 |  |  |  |  |  |  |  |  |  | 2006-01-13 00:00:00 |  |  |  |  |  | 2006-01-13 00:00:00 |  |  | 648913 | 587279
 |  |  |  |  |  |  |  |  |  | 2006-01-16 00:00:00 |  |  |  |  |  | 2006-01-16 00:00:00 |  |  | 291164 | 310344
 |  |  |  |  |  |  |  |  |  | 2006-01-17 00:00:00 |  |  |  |  |  | 2006-01-17 00:00:00 |  |  | 896804 | 844802
 |  |  |  |  |  |  |  |  |  | 2006-01-18 00:00:00 |  |  |  |  |  | 2006-01-18 00:00:00 |  |  | 1420572 | 1463816
 |  |  |  |  |  |  |  |  |  | 2006-01-19 00:00:00 |  |  |  |  |  | 2006-01-19 00:00:00 |  |  | 845261 | 698515
 |  |  |  |  |  |  |  |  |  | 2006-01-20 00:00:00 |  |  |  |  |  | 2006-01-20 00:00:00 |  |  | 686578 | 707851
 |  |  |  |  |  |  |  |  |  | 2006-01-23 00:00:00 |  |  |  |  |  | 2006-01-23 00:00:00 |  |  | 473282 | 444938