Fetch data from 1 table and post in another table in same excel sheet after pivoting

Loveleen

New member
Joined
Jan 7, 2014
Messages
1
Reaction score
0
Points
0
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
 

Attachments

  • post.xlsx
    10.7 KB · Views: 12
Top