Spreadsheet: 578941d1529583308-issue-translating-table-data-to-column-format-with-firm-year-datapoint-s666-pq-translating-table-data-to-column-format-with-firm-year-datapoint
Sheet: Sheet2

Firm | Year | Percent
Eli Lill | 2003 | 0.0882352941176471
Eli Lill | 2004 | 0.219512195121951
Eli Lill | 2005 | 0.222222222222222
Eli Lill | 2006 | 0.276595744680851
Eli Lill | 2007 | 0.32
Eli Lill | 2008 | 0.327272727272727
Eli Lill | 2009 | 0.375
Eli Lill | 2010 | 0.442622950819672
Eli Lill | 2011 | 0.421875
Eli Lill | 2012 | 0.46875
Eli Lill | 2013 | 0.446153846153846
Eli Lill | 2014 | 0.432835820895522
Eli Lill | 2015 | 0.418918918918919
Eli Lill | 2016 | 0.358974358974359
Eli Lill | 2017 | 0.329268292682927
[NAME] | 2004 | 0
[NAME] | 2005 | 0
[NAME] | 2006 | 0
[NAME] | 2007 | 0
[NAME] | 2008 | 0
[NAME] | 2009 | 0
[NAME] | 2010 | 0
[NAME] | 2011 | 0.1
[NAME] | 2012 | 0.0833333333333333
[NAME] | 2013 | 0.157894736842105
[NAME] | 2014 | 0.236842105263158
[NAME] | 2015 | 0.219512195121951
[NAME] | 2016 | 0.217391304347826
[NAME] | 2017 | 0.51063829787234
Genentec | 2003 | 0.28125
Genentec | 2004 | 0.242424242424242
Genentec | 2005 | 0.305555555555556
Genentec | 2006 | 0.425
Genentec | 2007 | 0.476190476190476
Genentec | 2008 | 0.476190476190476
Genentec | 2009 | 0.476190476190476
Genentec | 2010 | 0.372093023255814
Genentec | 2011 | 0.361702127659574
Genentec | 2012 | 0.326923076923077
Genentec | 2013 | 0.267857142857143
Genentec | 2014 | 0.233333333333333
Genentec | 2015 | 0.194029850746269
Genentec | 2016 | 0.159420289855072
Genentec | 2017 | 0.157142857142857
[NAME] Ph | 2003 | 0.173913043478261
[NAME] Ph | 2004 | 0.173913043478261
[NAME] Ph | 2005 | 0.269230769230769
[NAME] Ph | 2006 | 0.481481481481481
[NAME] Ph | 2007 | 0.451612903225806
[NAME] Ph | 2008 | 0.375
[NAME] Ph | 2009 | 0.444444444444444
[NAME] Ph | 2010 | 0.41025641025641
[NAME] Ph | 2011 | 0.390243902439024
[NAME] Ph | 2012 | 0.390243902439024
[NAME] Ph | 2013 | 0.255813953488372
[NAME] Ph | 2014 | 0.311111111111111
[NAME] Ph | 2015 | 0.276595744680851
[NAME] Ph | 2016 | 0.270833333333333
[NAME] Ph | 2017 | 0.326530612244898
Merck Sh | 2003 | 0.288888888888889
Merck Sh | 2004 | 0.322916666666667
Merck Sh | 2005 | 0.326732673267327
Merck Sh | 2006 | 0.358490566037736
Merck Sh | 2007 | 0.367521367521368
Merck Sh | 2008 | 0.358333333333333
Merck Sh | 2009 | 0.433333333333333
Merck Sh | 2010 | 0.322314049586777
Merck Sh | 2011 | 0.306451612903226
Merck Sh | 2012 | 0.317829457364341
Merck Sh | 2013 | 0.255639097744361
Merck Sh | 2014 | 0.288888888888889
Merck Sh | 2015 | 0.259259259259259
Merck Sh | 2016 | 0.188235294117647
Merck Sh | 2017 | 0.17816091954023
GlaxoSmi | 2003 | 0.292307692307692
GlaxoSmi | 2004 | 0.28
GlaxoSmi | 2005 | 0.435897435897436
GlaxoSmi | 2006 | 0.525641025641026
GlaxoSmi | 2007 | 0.536585365853659
GlaxoSmi | 2008 | 0.46
GlaxoSmi | 2009 | 0.433628318584071
GlaxoSmi | 2010 | 0.312925170068027
GlaxoSmi | 2011 | 0.283333333333333
GlaxoSmi | 2012 | 0.169724770642202
GlaxoSmi | 2013 | 0.124463519313305
GlaxoSmi | 2014 | 0.121951219512195
GlaxoSmi | 2015 | 0.162264150943396
GlaxoSmi | 2016 | 0.188405797101449
GlaxoSmi | 2017 | 0.277027027027027
Pharmaci | 2003 | 0.259842519685039
Pharmaci | 2004 | 0.291044776119403
Pharmaci | 2005 | 0.298507462686567
Pharmaci | 2006 | 0.311111111111111
Pharmaci | 2007 | 0.274074074074074
Pharmaci | 2008 | 0.325925925925926
Pharmaci | 2009 | 0.318518518518519
Pharmaci | 2010 | 0.192592592592593
Pharmaci | 2011 | 0.191176470588235
Pharmaci | 2012 | 0.160583941605839
Pharmaci | 2013 | 0.153284671532847
Pharmaci | 2014 | 0.121428571428571
Pharmaci | 2015 | 0.0657894736842105
Pharmaci | 2016 | 0.0645161290322581
Pharmaci | 2017 | 0.05
[NAME] | 2004 | 0
[NAME] | 2005 | 0
[NAME] | 2006 | 0
[NAME] | 2007 | 0
[NAME] | 2008 | 0
[NAME] | 2009 | 0
[NAME] | 2010 | 0
[NAME] | 2011 | 0.2
[NAME] | 2012 | 0.125
[NAME] | 2013 | 0.0625
[NAME] | 2014 | 0.0625
[NAME] | 2015 | 0.0625
[NAME] | 2016 | 0.0625
[NAME] | 2017 | 0.125