Spreadsheet: 578942d1529583548-issue-translating-table-data-to-column-format-with-firm-year-datapoint-s666-pq-translating-table-data-to-column-format-with-firm-year-datapoint-ver2
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] | 0
[NAME] 2006 | 0
[NAME] 2007 | 0
[NAME] | 0
[NAME] 2009 | 0
[NAME] | 0
[NAME] | 0.1
[NAME] 2012 | 0.0833333333333333
[NAME] | 0.157894736842105
[NAME] | 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] | 0.173913043478261
[NAME] Ph 2005 | 0.269230769230769
[NAME] Ph 2006 | 0.481481481481481
[NAME] 2007 | 0.451612903225806
[NAME] | 0.375
[NAME] Ph 2009 | 0.444444444444444
[NAME] 2010 | 0.41025641025641
[NAME] Ph 2011 | 0.390243902439024
[NAME] Ph 2012 | 0.390243902439024
[NAME] | 0.255813953488372
[NAME] Ph 2014 | 0.311111111111111
[NAME] | 0.276595744680851
[NAME] 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
[NAME] 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] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0.2
[NAME] | 0.125
[NAME] | 0.0625
[NAME] | 0.0625
[NAME] | 0.0625
[NAME] | 0.0625
[NAME] | 0.125