Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear friends,
I have a matrix like the one shown below 3 4 5 6 7 8 30x20 1.11 1.45 40x20 1.35 1.77 45x30 2.25 2.77 50x30 2.96 50x40 2.71 3.35 60x30 3.37 3.98 4.59 60x40 3.76 4.46 5.14 65x50 4.35 5.97 75x50 4.74 6.51 75x55 4.95 6.80 80x40 5.41 7.07 80x65 6.60 8.66 There are 2 axis: on horizontal (3, 4, 5...8) and on vertical (30x20....80x65). These two represents the lengths of the sides of uneven hot rolled angle and the horizontal is the thickness of the material. In the middle of the table I have the unitary weight for corresponding angle: ex. 30x20x3 (the angle sides x thick) has 1.11 kgs/linear meter. This actually look very much like a classic Pivot Table. Now, all what I need is to transform this "Pivot" into the original table which I think that should look like this: 30x20 3 1.11 30x20 4 1.45 30x20 5 0 .. .. .. 30x20 8 0 40x20 3 1.35 40x20 4 1.77 .. .. .. 80x65 8 8.66 Is there any way to do it like a reverse Pivot or is there any formula for it? If not, I think I need some VBA code... I use Excel 2003. Thank you in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem selecting a whole data matrix | Excel Programming | |||
Problem with a selection in a matrix-function | Excel Programming | |||
Excel problem with dynamic matrix with a name | Excel Programming | |||
Matrix Problem | Excel Discussion (Misc queries) | |||
vba problem lookup in a matrix | Excel Programming |