I have a table as mentioned below:
Name Age Income
jks 20 40
kjsj 21 80
kjk 20 60
kjdkj 22 40
And i want my output to look like:
Name/Age 19 20 21 22 23
jks 20 40 8
kjsj 40 80 16
kjk 30 60 12
kjdkj 20 40 8
Where the values in the left and right row is 50% and 20% of the corresponding value.
Please refer attached excel sheet for better preview
Thanks in Advance
Bookmarks