Thread: [Solved] create "catalog" table
View Single Post
 
Old 11-07-2011, 01:36 AM
4thangel 4thangel is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Nov 2011
Posts: 5
4thangel is on a distinguished road
Default
Hi Julie,

Thanks for the information. Nice filter on the pivot table.
Unfortunately it is not what I am looking for. In my original attached sheet the last table (most right) should be the outcome. This table I will export to a paper catalog with smallest space required. Note that the attached file is only a fraction of my complete file existing of 2000 P/N.
The P/N should be in the matrix area while the dimension (L) at the top.ID and DF at the vertical ax. The left table is my input data and the middle table is the closest that I will get when I use a pivot table.

Thanks

Paul
Reply With Quote