Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,317
    Articles
    0
    Excel Version
    2010 on Xubuntu

Posting Permissions

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