Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2007
    Posts
    6

    Unanswered: Retreiving multiple columns from a pivot table

    Hello again,

    I am looking for a function that gives me multiple columns from a pivot table.
    I'll give an example:

    Number____Fund1____Fund2____Fund3____Fund4
    1234567___100_______________100______150
    1243567____________200____________________
    1324576___10________________200___________
    1023548_____________________800___________

    What i want to create is a list where the empty values are omitted

    OR

    A way to make a VLOOKUP go to the next row after finding the first result.

    My original table looks like this:

    Number____Fund____Value
    1234567___1_______100
    1234567___3_______100
    1234567___4_______150
    etc. etc.

    The data comes from a query in Access...

    Thnx in advance!

    Frederik
    The Netherlands
    Attached Thumbnails Attached Thumbnails Pivot.png   Table.png  
    Last edited by kipaaa; 07-30-07 at 08:59. Reason: Attach screenshots

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. Can you provide an example workbook with the data, then in same workbook another worksheet with the desired outcome?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jul 2007
    Posts
    6
    Thnx for your quick reply Shades :-)

    Luckily I already found the solution... In order to make a VLOOKUP do the job I had to make sure that every record is unique. I did so by adding an extension under "Number" (1234567-1) and making my VLOOKUP look for the extensions as well.

    That did the trick! (Oh and an example workbook would easily be 10 MB, a bit too much to post here i guess)

    Thanks again!

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Glad that you found the solution.

    By "sample" I meant with dummy data that would be ~20-30K in size.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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