Spreadsheet: 39202d1237394434-combining-merging-columns-columns-to-column
Sheet: desired output

2003-09-08 00:00:00 | this stuff is from the first column, just without the gaps in between the dates |  | THEN |  |  |  |  |  |  |  |  | 1998-12-21 00:00:00
2003-11-05 00:00:00 |  |  |  | the same dates from column A, but ordered by date and stripped of duplicates… |  |  |  |  |  |  |  | 1999-03-22 00:00:00
2003-12-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1999-07-29 00:00:00
2004-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1999-09-22 00:00:00
2004-02-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1999-12-22 00:00:00
2004-03-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2000-03-27 00:00:00
2004-04-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2000-06-29 00:00:00
2004-05-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2000-09-27 00:00:00
2004-06-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2000-12-21 00:00:00
2004-07-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2001-03-26 00:00:00
2004-08-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2001-06-26 00:00:00
2004-09-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2001-09-25 00:00:00
2004-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2001-12-20 00:00:00
2004-11-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2002-03-27 00:00:00
2004-12-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2002-06-28 00:00:00
2005-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2002-09-27 00:00:00
2005-02-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2002-12-23 00:00:00
2005-03-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2003-03-27 00:00:00
2005-04-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2003-06-27 00:00:00
2005-05-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2003-09-08 00:00:00
2005-06-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2003-09-30 00:00:00
2005-07-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2003-11-05 00:00:00
2005-08-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2003-12-08 00:00:00
2005-09-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2003-12-23 00:00:00
2005-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-01-13 00:00:00
2005-11-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-02-09 00:00:00
2005-12-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-03-09 00:00:00
2006-02-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-03-26 00:00:00
2006-03-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-04-05 00:00:00
2006-04-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-05-11 00:00:00
2006-05-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-06-09 00:00:00
2006-06-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-06-30 00:00:00
2006-07-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-07-06 00:00:00
2006-08-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-08-05 00:00:00
2006-09-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-09-07 00:00:00
2006-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-09-29 00:00:00
2006-11-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-10-06 00:00:00
2006-12-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-11-05 00:00:00
2007-01-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-12-06 00:00:00
2007-02-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2004-12-23 00:00:00
2007-03-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-01-13 00:00:00
2007-04-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-02-09 00:00:00
2007-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-03-09 00:00:00
2007-06-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-03-23 00:00:00
2007-07-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-04-07 00:00:00
2007-08-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-05-09 00:00:00
2007-09-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-06-09 00:00:00
2007-10-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-06-30 00:00:00
2007-11-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-07-06 00:00:00
2007-12-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-08-07 00:00:00
2008-01-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-09-06 00:00:00
2008-02-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-09-28 00:00:00
2008-03-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-10-06 00:00:00
2008-04-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-11-07 00:00:00
2008-05-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-12-06 00:00:00
2008-06-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-12-22 00:00:00
2008-07-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-02-08 00:00:00
2008-08-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-03-09 00:00:00
2008-09-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-03-29 00:00:00
2008-10-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-04-05 00:00:00
2008-11-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-05-11 00:00:00
2008-12-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-06-08 00:00:00
2009-01-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-06-30 00:00:00
2009-02-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-07-06 00:00:00
2009-03-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-08-07 00:00:00
1998-12-21 00:00:00 | this stuff is from the second column, just without the gaps in between the dates |  |  |  |  |  |  |  |  |  |  | 2006-09-06 00:00:00
1999-03-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-09-27 00:00:00
1999-07-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-10-06 00:00:00
1999-09-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-11-06 00:00:00
1999-12-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-12-06 00:00:00
2000-03-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2006-12-21 00:00:00
2000-06-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-01-11 00:00:00
2000-09-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-02-07 00:00:00
2000-12-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-03-09 00:00:00
2001-03-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-03-28 00:00:00
2001-06-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-04-05 00:00:00
2001-09-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-05-10 00:00:00
2001-12-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-06-08 00:00:00
2002-03-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-06-29 00:00:00
2002-06-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-07-06 00:00:00
2002-09-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-08-06 00:00:00
2002-12-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-09-06 00:00:00
2003-03-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-09-26 00:00:00
2003-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-10-08 00:00:00
2003-09-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-11-05 00:00:00
2003-12-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-12-06 00:00:00
2004-03-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2007-12-20 00:00:00
2004-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-01-11 00:00:00
2004-09-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-02-07 00:00:00
2004-12-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-03-10 00:00:00
2005-03-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-03-28 00:00:00
2005-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-04-09 00:00:00
2005-09-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-05-07 00:00:00
2005-12-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-06-10 00:00:00
2006-03-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-06-27 00:00:00
2006-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-07-07 00:00:00
2006-09-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-08-05 00:00:00
2006-12-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-09-09 00:00:00
2007-03-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-09-30 00:00:00
2007-06-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-10-07 00:00:00
2007-09-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-11-05 00:00:00
2007-12-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-12-09 00:00:00
2008-03-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2008-12-23 00:00:00
2008-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2009-01-09 00:00:00
2008-09-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2009-02-06 00:00:00
2008-12-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2009-02-25 00:00:00
2009-02-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2009-03-10 00:00:00
2009-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2009-06-30 00:00:00
etc… |  |  |  |  |  |  |  |  |  |  |  | etc…