Results 1 to 2 of 2

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

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

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

    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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •