Pivoting table to get output in 3 adjacent cells where each value is percentage of other

Hi,

I have a table as below:

Name Month Income
Apple Dec-13 80
MS Mar-14 40
Samsung Sep-13 60
Sony Nov-13 40

And want output as below.
Name/Age Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14
Apple 40 80 16
MS 20 40 8
Samsung 30 60 12
Sony 20 40 8

Please refer attached sheet for more clear data.


--Loveleen