Re: Multi-dimensional VLOOKUP / PivotTable ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Ola, thanks for all your help; however, I think I mistated my question.

I do not want to transform the data into a new layout with a "top row."
The way the data is stored originally has the top row.

So, in theory, I want to say: level1->level2->level3@TOP1 ==> <value>
Where TOP1 is a column header, and the levels are row categories.

See the right-side table in my last attachment to see how the data is
originally stored.

Tack!


--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22440
View this thread: http://www.excelforum.com/showthread.php?threadid=378233

.

Relevant Pages

  • DIY Tube Amp
    ... have you got schematics and layout? ... Ola ... Prev by Date: ...
    (alt.guitar.amps)
  • Re: How to teach someone HTML/CSS?
    ... > to build a fluid design from a fixed size PSD ... to transform into HTML + CSS, ... For example a layout with oblique edges can require a lot ... for a graphic designer to have a few Photoshop alternatives ...
    (alt.html)
  • Re: How to teach someone HTML/CSS?
    ... Turning a PSD into an HTML/CSS layout - how ... to transform into HTML + CSS, ... for a graphic designer to have a few Photoshop alternatives ...
    (alt.html)
  • Re: x y coordinates
    ... instances down the heirarchy in a layout view. ... If you have the instIds for the different levels of the hierarchy, ... geGetInstTransform to get the resulting overall transform. ... ?cellname cellname ...
    (comp.cad.cadence)
  • Re: x y coordinates
    ... instances down the heirarchy in a layout view. ... If you have the instIds for the different levels of the hierarchy, then pass this list to geGetInstTransform to get the resulting overall transform. ... respect to inst1 are given by ...
    (comp.cad.cadence)