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...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=378233