Spreadsheet: 475113d1471099494-transpose-identified-duplicate-names-to-a-single-row-sample-gk2
Sheet: Sheet2

DATE | FIRMS | VALUE |  |  |  | DATE
2000-07-19 00:00:00 | aaa | 3.6 |  | No of dates
2000-08-19 00:00:00 | aaa | 3.29
2000-09-19 00:00:00 | aaa | 3.11
2000-10-19 00:00:00 | aaa | 2.96
2000-11-19 00:00:00 | aaa | 2.99
2000-12-19 00:00:00 | aaa | 2.51
2001-01-19 00:00:00 | aaa | 2.67
2001-02-19 00:00:00 | aaa | 2.93
2001-03-19 00:00:00 | aaa | 2.61
2001-04-19 00:00:00 | aaa | 3.69
2001-05-19 00:00:00 | aaa | 6.31
2001-06-19 00:00:00 | aaa | 6.79
2001-07-19 00:00:00 | aaa | 6.64
2001-08-19 00:00:00 | aaa | 6.74
2001-09-19 00:00:00 | aaa | 6.68
2001-10-19 00:00:00 | aaa | 6.66
2001-11-19 00:00:00 | aaa | 6.66
2001-12-19 00:00:00 | aaa | 6.22
2002-01-19 00:00:00 | aaa | 6.13
2002-02-19 00:00:00 | aaa | 3.39
2002-03-19 00:00:00 | aaa | 4.59
2002-04-19 00:00:00 | aaa | 7.22
2002-05-19 00:00:00 | aaa | 10.86
2002-06-19 00:00:00 | aaa | 7.44
2002-07-19 00:00:00 | aaa | 9.02
2002-08-19 00:00:00 | aaa | 8.42
2002-09-19 00:00:00 | aaa | 11.7
2002-10-19 00:00:00 | aaa | 16.32
2002-11-19 00:00:00 | aaa | 16.29
2002-12-19 00:00:00 | aaa | 16.26
2003-01-19 00:00:00 | aaa | 16.27
2003-02-19 00:00:00 | aaa | 16.2
2003-03-19 00:00:00 | aaa | 3.51
2003-04-19 00:00:00 | aaa | 2.95
2003-05-19 00:00:00 | aaa | 3.74
2003-06-19 00:00:00 | aaa | 2.89
2003-07-19 00:00:00 | aaa | 2.96
2003-08-19 00:00:00 | aaa | 2.77
2003-09-19 00:00:00 | aaa | 2.61
2003-10-19 00:00:00 | aaa | 2.46
2003-11-19 00:00:00 | aaa | 2.7
2003-12-19 00:00:00 | aaa | 3.12
2004-01-19 00:00:00 | aaa | 2.8
2004-02-19 00:00:00 | aaa | 2.77
2004-03-19 00:00:00 | aaa | 2.82
2004-04-19 00:00:00 | aaa | 2.88
2004-05-19 00:00:00 | aaa | 2.74
2004-06-19 00:00:00 | aaa | 2.96
2004-07-19 00:00:00 | aaa | 3.54
2004-08-19 00:00:00 | aaa | 3.97
2004-09-19 00:00:00 | aaa | 4.45
2004-10-19 00:00:00 | aaa | 4.37
2004-11-19 00:00:00 | aaa | 4.17
2004-12-19 00:00:00 | aaa | 3.59
2005-01-19 00:00:00 | aaa | 3.85
2005-02-19 00:00:00 | aaa | 3.52
2005-03-19 00:00:00 | aaa | 3.43
2005-04-19 00:00:00 | aaa | 2.87
2005-05-19 00:00:00 | aaa | 2.35
2005-06-19 00:00:00 | aaa | 2.38
2005-07-19 00:00:00 | aaa | 1.96
2005-08-19 00:00:00 | aaa | 1.42
2005-09-19 00:00:00 | aaa | 1.35
2005-10-19 00:00:00 | aaa | 1.39
2005-11-19 00:00:00 | aaa | 1.1
2005-12-19 00:00:00 | aaa | 1.41
2006-01-19 00:00:00 | aaa | 1.8
2006-02-19 00:00:00 | aaa | 1.8
2006-03-19 00:00:00 | aaa | 2.14
2006-04-19 00:00:00 | aaa | 2.09
2006-05-19 00:00:00 | aaa | 2.09
2006-06-19 00:00:00 | aaa | 2.18
2006-07-19 00:00:00 | aaa | 2.07
2006-08-19 00:00:00 | aaa | 1.8
2006-09-19 00:00:00 | aaa | 1.84
2006-10-19 00:00:00 | aaa | 1.94
2006-11-19 00:00:00 | aaa | 1.83
2006-12-19 00:00:00 | aaa | 1.86
2007-01-19 00:00:00 | aaa | 2.23
2007-02-19 00:00:00 | aaa | 1.85
2007-03-19 00:00:00 | aaa | 1.94
2007-04-19 00:00:00 | aaa | 1.76
2007-05-19 00:00:00 | aaa | 1.92
2007-06-19 00:00:00 | aaa | 2.01
2007-07-19 00:00:00 | aaa | 2.25
2007-08-19 00:00:00 | aaa | 2.36
2007-09-19 00:00:00 | aaa | 2.54
2007-10-19 00:00:00 | aaa | 2.35
2007-11-19 00:00:00 | aaa | 2.06
2007-12-19 00:00:00 | aaa | 2.05
2008-01-19 00:00:00 | aaa | 1.69
2008-02-19 00:00:00 | aaa | 1.84
2008-03-19 00:00:00 | aaa | 1.72
2008-04-19 00:00:00 | aaa | 1.56
2008-05-19 00:00:00 | aaa | 1.42
2008-06-19 00:00:00 | aaa | 1.25
2008-07-19 00:00:00 | aaa | 1.29
2008-08-19 00:00:00 | aaa | 1.26
2008-09-19 00:00:00 | aaa | 1.23
2008-10-19 00:00:00 | aaa | 1.22
2008-11-19 00:00:00 | aaa | 1.43
2008-12-19 00:00:00 | aaa | 1.39
2009-01-19 00:00:00 | aaa | 1.34
2009-02-19 00:00:00 | aaa | 1.37
2009-03-19 00:00:00 | aaa | 1.27
2009-04-19 00:00:00 | aaa | 1.35
2009-05-19 00:00:00 | aaa | 1.49
2009-06-19 00:00:00 | aaa | 1.81
2009-07-19 00:00:00 | aaa | 2.05
2009-08-19 00:00:00 | aaa | 1.97
2009-09-19 00:00:00 | aaa | 1.76
2009-10-19 00:00:00 | aaa | 1.68
2009-11-19 00:00:00 | aaa | 1.61
2009-12-19 00:00:00 | aaa | 1.56
2010-01-19 00:00:00 | aaa | 1.49
2010-02-19 00:00:00 | aaa | 1.45
2010-03-19 00:00:00 | aaa | 1.31
2010-04-19 00:00:00 | aaa | 1.38
2010-05-19 00:00:00 | aaa | 1.48
2010-06-19 00:00:00 | aaa | 1.53
2010-07-19 00:00:00 | aaa | 1.78
2010-08-19 00:00:00 | aaa | 1.92
2010-09-19 00:00:00 | aaa | 1.87
2010-10-19 00:00:00 | aaa | 1.93
2010-11-19 00:00:00 | aaa | 1.99
2010-12-19 00:00:00 | aaa | 1.96
2011-01-19 00:00:00 | aaa | 2.1
2011-02-19 00:00:00 | aaa | 1.82
2011-03-19 00:00:00 | aaa | 1.87
2011-04-19 00:00:00 | aaa | 2.01
2011-05-19 00:00:00 | aaa | 2.67
2011-06-19 00:00:00 | aaa | 2.58
2011-07-19 00:00:00 | aaa | 2.58
2011-08-19 00:00:00 | aaa | 2.65
2011-09-19 00:00:00 | aaa | 2.51
2011-10-19 00:00:00 | aaa | 2.42
2011-11-19 00:00:00 | aaa | 2.71
2011-12-19 00:00:00 | aaa | 2.6
2012-01-19 00:00:00 | aaa | 2.55
2012-02-19 00:00:00 | aaa | 2.93
2012-03-19 00:00:00 | aaa | 2.96
2012-04-19 00:00:00 | aaa | 2.77
2012-05-19 00:00:00 | aaa | 2.71
2012-06-19 00:00:00 | aaa | 2.73
2012-07-19 00:00:00 | aaa | 2.88
2012-08-19 00:00:00 | aaa | 2.65
2012-09-19 00:00:00 | aaa | 2.52
2012-10-19 00:00:00 | aaa | 2.43
2012-11-19 00:00:00 | aaa | 2.65
2012-12-19 00:00:00 | aaa | 2.41
2013-01-19 00:00:00 | aaa | 2.7
2013-02-19 00:00:00 | aaa | 2.59
2013-03-19 00:00:00 | aaa | 2.56
2013-04-19 00:00:00 | aaa | 2.52
2013-05-19 00:00:00 | aaa | 8.99
2013-06-19 00:00:00 | aaa | 8.99
2013-07-19 00:00:00 | aaa | 8.99
2013-08-19 00:00:00 | aaa | 8.99
2013-09-19 00:00:00 | aaa | 8.99
2013-10-19 00:00:00 | aaa | 8.99
2013-11-19 00:00:00 | aaa | 8.99
2013-12-19 00:00:00 | aaa | 8.99
2014-01-19 00:00:00 | aaa | 8.99
2014-02-19 00:00:00 | aaa | 8.99
2014-03-19 00:00:00 | aaa | 8.99
2014-04-19 00:00:00 | aaa | 8.99
2014-05-19 00:00:00 | aaa | 8.99
2014-06-19 00:00:00 | aaa | 8.99
2014-07-19 00:00:00 | aaa | 8.99
2014-08-19 00:00:00 | aaa | 8.99
2014-09-19 00:00:00 | aaa | 8.99
2014-10-19 00:00:00 | aaa | 8.99
2014-11-19 00:00:00 | aaa | 8.99
2014-12-19 00:00:00 | aaa | 8.99
2015-01-19 00:00:00 | aaa | 8.99
2015-02-19 00:00:00 | aaa | 8.99
2015-03-19 00:00:00 | aaa | 8.99
2015-04-19 00:00:00 | aaa | 8.99
2015-05-19 00:00:00 | aaa | 0.24
2015-06-19 00:00:00 | aaa | 0.25
2015-07-19 00:00:00 | aaa | 0.25
2015-08-19 00:00:00 | aaa | 0.25
2015-09-19 00:00:00 | aaa | 0.24
2015-10-19 00:00:00 | aaa | 0.24
2015-11-19 00:00:00 | aaa | 0.23
2015-12-19 00:00:00 | aaa | 0.24
2016-01-19 00:00:00 | aaa | 0.21
2016-02-19 00:00:00 | aaa | 0.21
2016-03-19 00:00:00 | aaa | 0.24
2016-04-19 00:00:00 | aaa | 0.31
2016-05-19 00:00:00 | aaa | 0.31
2016-06-19 00:00:00 | aaa | 0.29
2016-07-19 00:00:00 | aaa | 0.31
2000-07-19 00:00:00 | [NAME] | 0.31
2000-08-19 00:00:00 | [NAME] | 0.3
2000-09-19 00:00:00 | [NAME] | 0.31
2000-10-19 00:00:00 | [NAME] | 0.3
2000-11-19 00:00:00 | [NAME] | 0.3
2000-12-19 00:00:00 | [NAME] | 0.3
2001-01-19 00:00:00 | [NAME] | 0.3
2001-02-19 00:00:00 | [NAME] | 0.3
2001-03-19 00:00:00 | [NAME] | 0.29
2001-04-19 00:00:00 | [NAME] | 0.29
2001-05-19 00:00:00 | [NAME] | 0.28
2001-06-19 00:00:00 | [NAME] | 0.25
2001-07-19 00:00:00 | [NAME] | 0.26
2001-08-19 00:00:00 | [NAME] | 0.31
2001-09-19 00:00:00 | [NAME] | 0.29
2001-10-19 00:00:00 | [NAME] | 0.32
2001-11-19 00:00:00 | [NAME] | 0.5
2001-12-19 00:00:00 | [NAME] | 0.5
2002-01-19 00:00:00 | [NAME] | 0.53
2002-02-19 00:00:00 | [NAME] | 0.54
2002-03-19 00:00:00 | [NAME] | 0.59
2002-04-19 00:00:00 | [NAME] | 0.64
2002-05-19 00:00:00 | [NAME] | 0.63
2002-06-19 00:00:00 | [NAME] | 0.61
2002-07-19 00:00:00 | [NAME] | 0.7
2002-08-19 00:00:00 | [NAME] | 0.92
2002-09-19 00:00:00 | [NAME] | 0.92
2002-10-19 00:00:00 | [NAME] | 0.96
2002-11-19 00:00:00 | [NAME] | 1.04
2002-12-19 00:00:00 | [NAME] | 1.2
2003-01-19 00:00:00 | [NAME] | 1.03
2003-02-19 00:00:00 | [NAME] | 0.94
2003-03-19 00:00:00 | [NAME] | 0.83
2003-04-19 00:00:00 | [NAME] | 0.89
2003-05-19 00:00:00 | [NAME] | 0.98
2003-06-19 00:00:00 | [NAME] | 1.19
2003-07-19 00:00:00 | [NAME] | 1.12
2003-08-19 00:00:00 | [NAME] | 1.13
2003-09-19 00:00:00 | [NAME] | 1.6
2003-10-19 00:00:00 | [NAME] | 1.63
2003-11-19 00:00:00 | [NAME] | 1.47
2003-12-19 00:00:00 | [NAME] | 1.71
2004-01-19 00:00:00 | [NAME] | 1.55
2004-02-19 00:00:00 | [NAME] | 1.5
2004-03-19 00:00:00 | [NAME] | 1.5
2004-04-19 00:00:00 | [NAME] | 1.5
2004-05-19 00:00:00 | [NAME] | 1.79
2004-06-19 00:00:00 | [NAME] | 2.3
2004-07-19 00:00:00 | [NAME] | 2.46
2004-08-19 00:00:00 | [NAME] | 2.33
2004-09-19 00:00:00 | [NAME] | 2.25
2004-10-19 00:00:00 | [NAME] | 2.49
2004-11-19 00:00:00 | [NAME] | 2.33
2004-12-19 00:00:00 | [NAME] | 2.13
2005-01-19 00:00:00 | [NAME] | 2.2
2005-02-19 00:00:00 | [NAME] | 2.19
2005-03-19 00:00:00 | [NAME] | 2.19
2005-04-19 00:00:00 | [NAME] | 1.9
2005-05-19 00:00:00 | [NAME] | 1.61
2005-06-19 00:00:00 | [NAME] | 1.77
2005-07-19 00:00:00 | [NAME] | 1.49
2005-08-19 00:00:00 | [NAME] | 1.35
2005-09-19 00:00:00 | [NAME] | 1.21
2005-10-19 00:00:00 | [NAME] | 1.25
2005-11-19 00:00:00 | [NAME] | 1.17
2005-12-19 00:00:00 | [NAME] | 1.42
2006-01-19 00:00:00 | [NAME] | 1.61
2006-02-19 00:00:00 | [NAME] | 1.66
2006-03-19 00:00:00 | [NAME] | 1.66
2006-04-19 00:00:00 | [NAME] | 1.55
2006-05-19 00:00:00 | [NAME] | 1.49
2006-06-19 00:00:00 | [NAME] | 1.52
2006-07-19 00:00:00 | [NAME] | 1.33
2006-08-19 00:00:00 | [NAME] | 1.07
2006-09-19 00:00:00 | [NAME] | 1.01
2006-10-19 00:00:00 | [NAME] | 1.01
2006-11-19 00:00:00 | [NAME] | 0.94
2006-12-19 00:00:00 | [NAME] | 0.8
2007-01-19 00:00:00 | [NAME] | 0.97
2007-02-19 00:00:00 | [NAME] | 0.77
2007-03-19 00:00:00 | [NAME] | 0.8
2007-04-19 00:00:00 | [NAME] | 0.8
2007-05-19 00:00:00 | [NAME] | 0.84
2007-06-19 00:00:00 | [NAME] | 0.8
2007-07-19 00:00:00 | [NAME] | 0.84
2007-08-19 00:00:00 | [NAME] | 0.9
2007-09-19 00:00:00 | [NAME] | 1.07
2007-10-19 00:00:00 | [NAME] | 1.23
2007-11-19 00:00:00 | [NAME] | 1.11
2007-12-19 00:00:00 | [NAME] | 1.11
2008-01-19 00:00:00 | [NAME] | 1.56
2008-02-19 00:00:00 | [NAME] | 1.49
2008-03-19 00:00:00 | [NAME] | 1.52
2008-04-19 00:00:00 | [NAME] | 1.43
2008-05-19 00:00:00 | [NAME] | 1.28
2008-06-19 00:00:00 | [NAME] | 1.32
2008-07-19 00:00:00 | [NAME] | 1.34
2008-08-19 00:00:00 | [NAME] | 1.18
2008-09-19 00:00:00 | [NAME] | 1.18
2008-10-19 00:00:00 | [NAME] | 1.18
2008-11-19 00:00:00 | [NAME] | 1.27
2008-12-19 00:00:00 | [NAME] | 1.2
2009-01-19 00:00:00 | [NAME] | 1.08
2009-02-19 00:00:00 | [NAME] | 1.12
2009-03-19 00:00:00 | [NAME] | 1.13
2009-04-19 00:00:00 | [NAME] | 1.17
2009-05-19 00:00:00 | [NAME] | 1.18
2009-06-19 00:00:00 | [NAME] | 1.29
2009-07-19 00:00:00 | [NAME] | 1.32
2009-08-19 00:00:00 | [NAME] | 1.19
2009-09-19 00:00:00 | [NAME] | 1.2
2009-10-19 00:00:00 | [NAME] | 1.24
2009-11-19 00:00:00 | [NAME] | 1.26
2009-12-19 00:00:00 | [NAME] | 1.16
2010-01-19 00:00:00 | [NAME] | 1.16
2010-02-19 00:00:00 | [NAME] | 1.12
2010-03-19 00:00:00 | [NAME] | 0.89
2010-04-19 00:00:00 | [NAME] | 1.04
2010-05-19 00:00:00 | [NAME] | 1.04
2010-06-19 00:00:00 | [NAME] | 1.06
2010-07-19 00:00:00 | [NAME] | 1.09
2010-08-19 00:00:00 | [NAME] | 1.12
2010-09-19 00:00:00 | [NAME] | 1.11
2010-10-19 00:00:00 | [NAME] | 1.11
2010-11-19 00:00:00 | [NAME] | 1.1
2010-12-19 00:00:00 | [NAME] | 1.19
2011-01-19 00:00:00 | [NAME] | 1.08
2011-02-19 00:00:00 | [NAME] | 1.1
2011-03-19 00:00:00 | [NAME] | 1.06
2011-04-19 00:00:00 | [NAME] | 1.04
2011-05-19 00:00:00 | [NAME] | 1.08
2011-06-19 00:00:00 | [NAME] | 1.06
2011-07-19 00:00:00 | [NAME] | 0.96
2011-08-19 00:00:00 | [NAME] | 1.1
2011-09-19 00:00:00 | [NAME] | 1.05
2011-10-19 00:00:00 | [NAME] | 1.12
2011-11-19 00:00:00 | [NAME] | 1.11
2011-12-19 00:00:00 | [NAME] | 1.14
2012-01-19 00:00:00 | [NAME] | 1.19
2012-02-19 00:00:00 | [NAME] | 1.25
2012-03-19 00:00:00 | [NAME] | 1.33
2012-04-19 00:00:00 | [NAME] | 1.35
2012-05-19 00:00:00 | [NAME] | 1.29
2012-06-19 00:00:00 | [NAME] | 1.22
2012-07-19 00:00:00 | [NAME] | 1.31
2012-08-19 00:00:00 | [NAME] | 1.34
2012-09-19 00:00:00 | [NAME] | 1.47
2012-10-19 00:00:00 | [NAME] | 1.35
2012-11-19 00:00:00 | [NAME] | 1.33
2012-12-19 00:00:00 | [NAME] | 1.29
2013-01-19 00:00:00 | [NAME] | 1.15
2013-02-19 00:00:00 | [NAME] | 1.23
2013-03-19 00:00:00 | [NAME] | 1.08
2013-04-19 00:00:00 | [NAME] | 1.1
2013-05-19 00:00:00 | [NAME] | 7.46
2013-06-19 00:00:00 | [NAME] | 7.45
2013-07-19 00:00:00 | [NAME] | 7.27
2013-08-19 00:00:00 | [NAME] | 6.92
2013-09-19 00:00:00 | [NAME] | 6.87
2013-10-19 00:00:00 | [NAME] | 6.61
2013-11-19 00:00:00 | [NAME] | 6.68
2013-12-19 00:00:00 | [NAME] | 6.34
2014-01-19 00:00:00 | [NAME] | 6.26
2014-02-19 00:00:00 | [NAME] | 3.41
2014-03-19 00:00:00 | [NAME] | 2.8
2014-04-19 00:00:00 | [NAME] | 2.88
2014-05-19 00:00:00 | [NAME] | 2.71
2014-06-19 00:00:00 | [NAME] | 2.61
2014-07-19 00:00:00 | [NAME] | 2.73
2014-08-19 00:00:00 | [NAME] | 2.72
2014-09-19 00:00:00 | [NAME] | 2.63
2014-10-19 00:00:00 | [NAME] | 2.48
2014-11-19 00:00:00 | [NAME] | 2.59
2014-12-19 00:00:00 | [NAME] | 2.68
2015-01-19 00:00:00 | [NAME] | 2.94
2015-02-19 00:00:00 | [NAME] | 3.07
2015-03-19 00:00:00 | [NAME] | 2.87
2015-04-19 00:00:00 | [NAME] | 2.8
2015-05-19 00:00:00 | [NAME] | 2.82
2015-06-19 00:00:00 | [NAME] | 2.54
2015-07-19 00:00:00 | [NAME] | 2.66
2015-08-19 00:00:00 | [NAME] | 2.76
2015-09-19 00:00:00 | [NAME] | 2.71
2015-10-19 00:00:00 | [NAME] | 2.78
2015-11-19 00:00:00 | [NAME] | 2.8
2015-12-19 00:00:00 | [NAME] | 2.37
2016-01-19 00:00:00 | [NAME] | 1.96
2016-02-19 00:00:00 | [NAME] | 2.36
2016-03-19 00:00:00 | [NAME] | 1.99
2016-04-19 00:00:00 | [NAME] | 1.99
2016-05-19 00:00:00 | [NAME] | 1.91
2016-06-19 00:00:00 | [NAME] | 1.81
2016-07-19 00:00:00 | [NAME] | 1.82