Converting Matrix Data to Linear Data for Pivot Table

[kdinkins]

I have a matrix table with weight and miles as my table axes. I am trying to create a pivot table so that I can group the weights and miles into broader categories but cant do that (i don't think) until I can get the weight and miles into columnar format. I can't figure out how to get the matrix data into columnar data without just copying and pasting but then that makes the columnar data static and unchangeable if I want to change the formula that created the matrix in the first place.

From Miles
↓To Miles
↓Weight
↓100011001200130014001500109911991299139914991599501550 737782869195551600 747983889398601650 758085909599651700 7782879196101701750 7883889398103751800 79859095100105801850 81869197102107851900 82889398104109901950 8389951001061119511000 859096102108113

WeightMilesPremium10005017311005017712005018213005018614005019115005019516005011001700501105180050110919005011142000501118


Average of PremiumMilesWeight501-10001001-15001501-20001000-19991021191342000-29991471762013000-39991872262614000-49992252763205000-59992643243786000-69993033734357000-79993414214928000-89993794695499000-999941651560310000-10999453562658

 

[kdinkins]

I can e-mail the file if someone wants to take a look at it for me.