var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Retreiving multiple columns from a pivot table
I am looking for a function that gives me multiple columns from a pivot table.
I'll give an example:
What i want to create is a list where the empty values are omitted
A way to make a VLOOKUP go to the next row after finding the first result.
My original table looks like this:
The data comes from a query in Access...
Thnx in advance!
Last edited by kipaaa; 07-30-07 at
Reason: Attach screenshots
Howdy. Can you provide an example workbook with the data, then in same workbook another worksheet with the desired outcome?
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)
Glad that you found the solution.
By "sample" I meant with dummy data that would be ~20-30K in size.