and before it was like this:

this uses R language

Exercise 8: You are required to reshape the data frame so information should appear like that: fy company variable value Apple revenue 65225.0 Apple revenue 108249.0 Apple revenue 156508.0 1 2010 2 2011 3 2012 4 2010 Google revenue 29321.0 5 2011 Google revenue 37905.0 6 2012 Ggle revenue 50175.0 7 2010 Microsoft revenue 62484.0 8 2011 Microsoft revenue 69943.0 9 2012 Microsoft revenue 73723.0 10 2010 11 2011 12 2012 13 2010 Google profit 8505.0 14 2011 Gge profit 9737.0 15 2012 Google profit 10737.0 16 2010 Microsoft profit 18760.0 17 2011 Microsoft profit 23150.0 18 2012 Microsoft profit 16978.0 19 2010 20 2011 21 2012 22 2010 margin 23 2011 Google mrgin 24 2012 Google margin 25 2010 Microsoft margin 26 2011 Microsoft margin 27 2012 Microsoft margin Apple profit 14013.0 Apple profit 25922.0 Apple profit 41733.0 21.5 23.9 26.7 29.0 25.7 21.4 30.0 33.1 23.0 Apple margin Apple margin Apple margin