Spreadsheet: 752639d1634873711-transpose-horizontal-data-to-columns-joe-test-file
Sheet: Sheet5

823 | 1996-04-29 00:00:00 | 20.5
823 | 1996-04-29 00:00:00 | (blank) |  |  | 1248 | 1415 | 2077 | 2087 | 2338 | 2991 | 5614 | 5648 | 5909 | 6366 | 6591 | 6676 | 7261 | 7392 | 7409 | 7443 | 7469 | 7472 | 7479 | 7512 | 7516 | 7625 | 7798 | 8124 | 8315 | 8486 | 9717 | 9728 | 9811 | 10236 | 10326 | 10340 | 10348 | 10395 | 10513 | 10545 | 10604 | 10606 | 11715 | 11859 | 11943 | 11959 | 11967 | 11977 | 11981 | 12015 | 12016 | 12173 | 12264 | 12523 | 12561 | 12567 | 12583 | 12630 | 12873 | 13175 | 13203 | 13204 | 13205 | 13235 | 13257 | 13491 | 13586 | 13613 | 13623 | 13627 | 13840 | 37746 | 37808 | 39318 | 39806 | 40038 | 40068 | 40870 | 40888 | 40910 | 40912 | 41086 | 41194 | 41259 | 41971 | 42696 | 43362 | 43619 | 44147 | 44351 | 44359 | 44386 | 44566 | 44571 | 44619 | 44686 | 44699 | 44707 | 44824 | 45077 | 45472 | 45532 | 45566 | 46417 | 47977 | 48003 | 48171 | 48206 | 48209 | 48767 | 48849 | 48916 | 49004 | 49033 | 49219 | 49823 | 50206 | 50262 | 50285 | 50372 | 50379 | 50850 | 50904 | 51460 | 51550 | 51591 | 52826 | 53295 | 53385 | 53402 | 53466 | 53502 | 53549 | 53587 | 53824 | 53866 | 53952 | 53994 | 54117 | 54986 | 55036 | 55134 | 55358
823 | 1996-04-29 00:00:00 | 20.5 |  | 20.5 | 21.45 | 27.1 | 19.5 | 21.55 | 25 | 24.5 | 21.45 | 19.45 | 23.75 | 22.55 | 23.5 | 19.5 | 24.75 | 27.25 | 21.6 | 21.5 | 24.95 | 21.75 | 22.5 | 24.15 | 24.9 | 19.7 | 23.65 | 22.35 | 22.6 | 23.5 | 25.45 | 19.25 | 24.05 | 19.5 | 23 | 22.25 | 20.95 | 20.3 | 22.85 | 21.05 | 20.5 | 32.5 | 20.5 | 28.9 | 29.3 | 18.5 | 32.5 | 28.75 | 26.15 | 28.2 | 34.95 | 28.25 | 28.45 | 22 | 24.5 | 24.75 | 22.5 | 21.5 | 19.8 | 19.8 | 21.6 | 20.85 | 22.2 | 21.25 | 19.3 | 26.5 | 20.3 | 24.25 | 21.5 | 21.35 | 23.1 | 21.45 | 20.5 | 20.04 | 21.25 | 18.6 | 18.25 | 19.25 | 20.65 | 23.95 | 15 | 21.65 | 21.7 | 18.05 | 21.9 | 21.75 | 24.5 | 22 | 24.5 | 20.5 | 22.5 | 19.5 | 22.75 | 30 | 24.25 | 24.5 | 20.25 | 27.1 | 22.4 | 20.5 | 19 | 21.5 | 20.55 | 24.25 | 20.4 | 19.75 | 22.7 | 22.5 | 19.05 | 19.75 | 23.5 | 18.5 | 24.45 | 24.45 | 20.35 | 24.15 | 24.15 | 19.75 | 21.95 | 17.45 | 21.5 | 22.45 | 18.85 | 25 | 21.25 | 21.5 | 21.35 | 19.15 | 22.5 | 18 | 21.3 | 19.25 | 20.45 | 21.5 | 19.75 | 21.35 | 23.05 | 23.9 | 23.9 | 23 | 21.5 | 23.5 | 22.5
823 | 1996-04-29 00:00:00 | 22.5 |  | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | 15.25 | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | (blank)
823 | 1996-04-29 00:00:00 | 20.5 |  | 20.5 | 21.45 | 27.1 | 22.75 | 21.55 | 25 | 24.5 | 22.45 | 19.45 | 23.75 | 22.55 | 23.5 | 19.5 | 26.75 | 27.25 | 21.6 | 21.5 | 24.95 | 21.75 | 22.5 | 22.15 | 24.4 | 19.2 | 23.65 | 22.35 | 22.6 | 26.5 | 35.45 | 18.75 | 23.05 | 19.75 | 23 | 22.25 | 20.95 | 21.05 | 24.6 | 21.05 | 20.5 | 40.5 | 25.5 | 31.9 | 29.3 | 22.5 | 32.5 | 31.75 | 31.9 | 32.2 | 36.7 | 32.25 | 28.45 | 22 | 24.5 | 24.75 | 22.5 | 21.5 | 19.05 | 27.8 | 26.6 | 28.1 | 29.7 | 23 | 21.55 | 27.5 | 24.3 | 25.75 | 26 | 23.1 | 23.1 | 22.45 | 20.5 | 18.25 | 21.25 | 21.1 | 20.25 | 21.25 | 20.65 | 23.95 | 20 | 23.4 | 28.2 | 18.05 | 21.9 | 26.75 | 24.5 | 22 | 29.5 | 20.5 | 30.5 | 24.5 | 22.95 | 36.5 | 24.25 | 24.5 | 20.25 | 27.1 | 22.4 | 20.5 | 19 | 21.5 | 21.55 | 24.25 | 24.4 | 23.25 | 22.7 | 22.5 | 24.8 | 19.75 | 25.5 | 19.75 | 24.45 | 24.45 | 20.35 | 26.15 | 24.15 | 19.75 | 21.95 | 25.7 | 21.5 | 23.45 | 18.85 | 25 | 22.5 | 21.5 | 26.35 | 19.15 | 22.5 | 20 | 21.3 | 27 | 20.45 | 21.5 | 23.75 | 21.35 | 23.05 | 22.9 | 23.9 | 23 | 24 | 23.5 | 22.5
823 | 1996-04-29 00:00:00 | 20.5 |  | 22.5 | 27.45 | 30.1 | 22.75 | 24.55 | 25 | 26.5 | 21.45 | 19.45 | 23.75 | 24.55 | 26.5 | 24 | 27.75 | 30.25 | 26.6 | 26 | 27.95 | 26.75 | 25.5 | 27.65 | 29.4 | 25.2 | 24.85 | 22.35 | 25.6 | 26.5 | 25.45 | 29.75 | 26.55 | 24.75 | 23 | 26.5 | 25.2 | 25.05 | 26.6 | 26.05 | 25 | 40.5 | 27.5 | 31.9 | 29.3 | 22.5 | 32.5 | 31.75 | 31.9 | 32.2 | 36.7 | 32.25 | 28.45 | 22 | 24.5 | 24.75 | 22.5 | 21.5 | 25.55 | 25.8 | 27.6 | 30.1 | 30.7 | 24.75 | 21.55 | 29.5 | 26.3 | 39.75 | 33 | 28.6 | 31.75 | 22.95 | 25.75 | 18.25 | 23.25 | 21.1 | 24.25 | 21.25 | 24.15 | 23.95 | 23 | 23.4 | 28.2 | 23.05 | 29.9 | 30.75 | 26.5 | 22 | 29.5 | 28.5 | 22.5 | 27.5 | 38.5 | 36.5 | 25.25 | 27 | 21.25 | 27.1 | 23.4 | 24.5 | 19 | 21.5 | 21.55 | 27.75 | 24.4 | 25.25 | 26.7 | 22.5 | 25.8 | 19.75 | 25.5 | 20.5 | 24.45 | 24.45 | 20.35 | 28.15 | 24.15 | 19.75 | 21.95 | 25.7 | 21.5 | 24.45 | 20.85 | 25 | 22.5 | 21.5 | 26.35 | 19.65 | 22.5 | 20 | 23.3 | 29 | 22.45 | 25.5 | 24.75 | 26.35 | 23.05 | 27.9 | 25.9 | 23 | 37 | 26.5 | 22.5
823 | 1996-04-29 00:00:00 | 20.5 |  | 20.5 | 21.45 | 27.1 | 22.75 | 18.55 | 25 | 24.5 | 21.45 | 19.45 | 23.75 | 21.55 | 23.5 | 19.5 | 24.75 | 25.75 | 21.6 | 21.5 | 22.45 | 21.75 | 20 | 22.15 | 24.4 | 19.2 | 21.65 | 22.35 | 22.6 | 24.5 | 25.45 | 18.75 | 20.05 | 18.75 | 23 | 22.25 | 20.95 | 20.3 | 22.85 | 21.05 | 19 | 40.5 | 25.5 | 31.9 | 29.3 | 22.5 | 32.5 | 31.75 | 31.9 | 32.2 | 36.7 | 23.25 | 28.45 | 22 | 24.5 | 24.75 | 22.5 | 21.5 | 19.05 | 22.3 | 23.35 | 23.1 | 20.7 | 19.25 | 21.55 | 25.5 | 19.3 | 23.25 | 20.5 | 23.6 | 23.1 | 21.45 | 19.75 | 16.75 | 21.25 | 21.1 | 18.25 | 19.25 | 20.65 | 23.95 | 19.5 | 23.4 | 22.45 | 18.05 | 21.9 | 21.75 | 21.75 | 22 | 29.5 | 20.5 | 22.5 | 19.5 | 22.75 | 36.5 | 24.25 | 23.75 | 20.25 | 27.1 | 22.4 | 20.5 | 19 | 21.5 | 20.55 | 24.25 | 19.4 | 19.75 | 22.7 | 22.5 | 22.8 | 19.75 | 23.5 | 18 | 24.45 | 24.45 | 20.35 | 24.15 | 24.15 | 19.75 | 21.95 | 21.7 | 21.5 | 22.45 | 18.85 | 25 | 20.5 | 21.5 | 26.35 | 18.65 | 22.5 | 18 | 21.3 | 24 | 20.45 | 21.5 | 19.75 | 21.35 | 23.05 | 22.9 | 22.9 | 23 | 21.5 | 23.5 | 22.5
 |  |  |  | 20.5 | 21.45 | 30.1 | 22.75 | 21.55 | 25 | 24.5 | 21.45 | 19.45 | 23.75 | 21.55 | 23.5 | 19.5 | 24.75 | 27.25 | 21.6 | 21.5 | 24.95 | 21.75 | 22.5 | 22.15 | 24.4 | 19.7 | 21.65 | 22.35 | 22.6 | 24.5 | 25.45 | 18.75 | 20.05 | 18.75 | 23 | 22.25 | 20.95 | 19.05 | 22.85 | 21.05 | 19 | 40.5 | 25.5 | 31.9 | 29.3 | 22.5 | 32.5 | 31.75 | 31.9 | 32.2 | 36.7 | 28.25 | 28.45 | 22 | 24.5 | 24.75 | 22.5 | 21.5 | 19.05 | 22.3 | 25.6 | 23.1 | 20.7 | 19.25 | 21.55 | 25.5 | 20.3 | 22.25 | 21.5 | 23.6 | 23.1 | 21.45 | 19.75 | 16.75 | 21.25 | 21.1 | 18.25 | 19.25 | 20.65 | 23.95 | 19.5 | 23.4 | 22.45 | 18.05 | 21.9 | 22.75 | 21.75 | 22 | 29.5 | 20.5 | 22.5 | 19.5 | 22.75 | 36.5 | 24.25 | 23.75 | 20.25 | 27.1 | 23.4 | 20.5 | 19 | 21.5 | 21.55 | 24.25 | 19.4 | 19.75 | 22.7 | 22.5 | 22.8 | 19.75 | 23.5 | 18 | 24.45 | 24.45 | 20.35 | 24.15 | 24.15 | 19.75 | 21.95 | 21.7 | 21.5 | 22.45 | 18.85 | 25 | 20.5 | 21.5 | 26.35 | 18.65 | 22.5 | 18 | 21.3 | 29 | 20.45 | 21.5 | 19.75 | 21.35 | 23.05 | 22.9 | 22.9 | 23 | 21.5 | 23.5 | 22.5
1248 | 1999-01-04 00:00:00 | 21.45 |  | 20.5 | 21.45 | 27.1 | 22.75 | 21.55 | 25 | 24.5 | 21.45 | 19.45 | 23.75 | 22.55 | 23.5 | 19.5 | 24.75 | 27.25 | 21.6 | 21.5 | 24.95 | 21.75 | 22.5 | 24.15 | 24.9 | 19.7 | 23.65 | 22.35 | 22.6 | 23.5 | 25.45 | 19.25 | 24.05 | 19.5 | 23 | 22.25 | 20.95 | 20.3 | 22.85 | 21.05 | 20.5 | 40.5 | 25.5 | 31.9 | 29.3 | 22.5 | 32.5 | 31.75 | 31.9 | 32.2 | 36.7 | 28.25 | 28.45 | 16 | 24.5 | 24.75 | 17 | 21.5 | 19.8 | 24.3 | 41.6 | 25.35 | 24.2 | 20 | 22.8 | 25.5 | 20.3 | 24.25 | 21.5 | 21.35 | 23.1 | 21.45 | 20.5 | 16.75 | 21.25 | 22.1 | 18.25 | 19.25 | 20.65 | 23.95 | 19.5 | 24.4 | 22.45 | 18.05 | 21.9 | 22.75 | 24.5 | 22 | 29.5 | 20.5 | 22.5 | 19.5 | 22.75 | 36.5 | 24.25 | 23.75 | 20.25 | 27.1 | 22.4 | 20.5 | 19 | 21.5 | 21.55 | 24.25 | 20.4 | 19.75 | 22.7 | 22.5 | 22.8 | 19.75 | 23.5 | 18 | 24.45 | 24.45 | 20.35 | 24.15 | 24.15 | 19.75 | 21.95 | 21.7 | 21.5 | 22.45 | 18.85 | 25 | 20.5 | 21.5 | 26.35 | 17.65 | 22.5 | 18 | 21.3 | 24 | 20.45 | 21.5 | 19.75 | 21.35 | 23.05 | 22.9 | 22.9 | 23 | 21.5 | 23.5 | 22.5
1248 | 1999-01-04 00:00:00 | (blank)
1248 | 1999-01-04 00:00:00 | 21.45 |  |  | Need these columns to stack like the first.
1248 | 1999-01-04 00:00:00 | 27.45
1248 | 1999-01-04 00:00:00 | 21.45 |  |  | each column matches to one number
1248 | 1999-01-04 00:00:00 | 21.45
1248 | 1999-01-04 00:00:00 | 21.45
1415 | 1999-10-04 00:00:00
2077 | 2001-10-08 00:00:00
2087 | 2001-10-18 00:00:00
2338 | 2013-07-22 00:00:00
2991 | 2004-11-22 00:00:00
5614 | 2010-06-21 00:00:00
5648 | 2010-07-19 00:00:00
5909 | 2011-01-03 00:00:00
6366 | 2011-07-05 00:00:00
6591 | 1997-01-02 00:00:00
6676 | 2004-02-02 00:00:00
7261 | 2012-07-30 00:00:00
7392 | 2011-10-12 00:00:00
7409 | 2007-05-07 00:00:00
7443 | 2012-03-19 00:00:00
7469 | 1982-02-01 00:00:00
7472 | 2011-05-31 00:00:00
7479 | 1996-01-01 00:00:00
7512 | 2007-10-10 00:00:00
7516 | 2012-05-29 00:00:00
7625 | 2002-12-23 00:00:00
7798 | 2012-10-01 00:00:00
8124 | 2010-09-13 00:00:00
8315 | 2012-08-13 00:00:00
8486 | 2013-05-09 00:00:00
9717 | 2014-01-06 00:00:00
9728 | 2014-01-03 00:00:00
9811 | 2014-01-27 00:00:00
10236 | 2001-07-09 00:00:00
10326 | 2007-10-29 00:00:00
10340 | 2009-01-27 00:00:00
10348 | 2006-10-03 00:00:00
10395 | 2006-10-16 00:00:00
10513 | 2004-10-18 00:00:00
10545 | 2004-10-06 00:00:00
10604 | 1996-10-01 00:00:00
10606 | 2006-01-16 00:00:00
11715 | 2014-06-02 00:00:00
11859 | 2013-07-08 00:00:00
11943 | 2013-01-11 00:00:00
11959 | 2011-10-24 00:00:00
11967 | 2007-07-05 00:00:00
11977 | 2012-10-23 00:00:00
11981 | 2013-07-29 00:00:00
12015 | 2014-07-08 00:00:00
12016 | 2013-07-24 00:00:00
12173 | 2011-11-28 00:00:00
12264 | 2014-02-10 00:00:00
12523 | 2007-10-22 00:00:00
12561 | 2011-10-03 00:00:00
12567 | 2001-12-17 00:00:00
12583 | 2001-05-21 00:00:00
12630 | 2013-02-18 00:00:00
12873 | 2013-12-21 00:00:00
13175 | 2014-05-19 00:00:00
13203 | 2013-02-25 00:00:00
13204 | 2013-02-25 00:00:00
13205 | 2011-03-01 00:00:00
13235 | 2010-11-23 00:00:00
13257 | 2009-05-13 00:00:00
13491 | 2015-09-14 00:00:00
13586 | 2001-04-16 00:00:00
13613 | 2000-10-02 00:00:00
13623 | 2007-04-16 00:00:00
13627 | 2010-07-18 00:00:00
13840 | 2006-07-18 00:00:00
37746 | 2014-10-01 00:00:00
37808 | 2014-10-13 00:00:00
39318 | 2015-04-27 00:00:00
39806 | 2015-07-06 00:00:00
40038 | 2015-07-21 00:00:00
40068 | 2015-07-22 00:00:00
40870 | 2015-10-12 00:00:00
40888 | 2015-10-12 00:00:00
40910 | 2015-10-19 00:00:00
40912 | 2015-10-14 00:00:00
41086 | 2015-10-27 00:00:00
41194 | 2015-11-11 00:00:00
41259 | 2015-11-09 00:00:00
41971 | 2016-01-25 00:00:00
42696 | 2016-04-04 00:00:00
43362 | 2016-10-10 00:00:00
43619 | 2016-07-11 00:00:00
44147 | 2016-10-03 00:00:00
44351 | 2016-09-26 00:00:00
44359 | 2016-09-19 00:00:00
44386 | 2007-06-11 00:00:00
44566 | 2016-10-10 00:00:00
44571 | 2016-10-10 00:00:00
44619 | 2016-10-17 00:00:00
44686 | 2016-10-24 00:00:00
44699 | 2016-10-25 00:00:00
44707 | 2016-10-24 00:00:00
44824 | 2016-11-07 00:00:00
45077 | 2016-12-07 00:00:00
45472 | 2017-01-30 00:00:00
45532 | 2017-01-30 00:00:00
45566 | 2017-01-24 00:00:00
46417 | 2017-04-24 00:00:00
47977 | 2017-10-02 00:00:00
48003 | 2017-10-02 00:00:00
48171 | 2017-10-18 00:00:00
48206 | 2017-10-30 00:00:00
48209 | 2017-10-23 00:00:00
48767 | 2018-01-03 00:00:00
48849 | 2018-01-15 00:00:00
48916 | 2018-01-15 00:00:00
49004 | 2018-01-22 00:00:00
49033 | 2018-01-22 00:00:00
49219 | 2018-02-19 00:00:00
49823 | 2018-04-30 00:00:00
50206 | 2018-07-09 00:00:00
50262 | 2018-07-30 00:00:00
50285 | 2018-07-30 00:00:00
50372 | 2018-07-30 00:00:00
50379 | 2018-07-30 00:00:00
50850 | 2018-10-22 00:00:00
50904 | 2018-10-22 00:00:00
51460 | 2019-01-28 00:00:00
51550 | 2019-01-21 00:00:00
51591 | 2019-01-29 00:00:00
52826 | 2019-07-22 00:00:00
53295 | 2019-09-19 00:00:00
53385 | 2019-10-21 00:00:00
53402 | 2019-10-08 00:00:00
53466 | 2019-11-04 00:00:00
53502 | 2019-10-14 00:00:00
53549 | 2019-10-23 00:00:00
53587 | 2019-10-28 00:00:00
53824 | 2019-11-29 00:00:00
53866 | 2019-12-09 00:00:00
53952 | 2020-01-06 00:00:00
53994 | 2020-01-20 00:00:00
54117 | 2020-01-27 00:00:00
54986 | 2020-10-05 00:00:00
55036 | 2020-10-19 00:00:00
55134 | 2020-10-26 00:00:00
55358 | 2021-01-04 00:00:00