It's about 63 MB's (in .csv or .txt format) and about 1 million records ... View more

Yes, with 1 million records.. when I export into .csv.. then pivot works but not the SUM.  In my sample I left a ' ' where the actual number eg 345345 would be and another ' ' where 245345 would be, but in my case I have alot of spaces.. Which I think are the culprit. ... View more

Thanks Cynthia, worked perfectly... would you know how I can make the percent not be multiplied by 100. and show as 0.352 rather than 35.2 ?  Thanks ... View more

Sometimes you forget the simple ways... I over 'thought' it .. thanks ... View more

Thanks guys as usual... all equally helpful.. ... View more

Ok, I'll try to simplify it a little: HAVE:                              UN_rt      /      Price TO    SC  Model1      6.7            34.56 TO    SC  Model2      6.4            56.77 TO    NY  Model1      6.4            56.77 TO    NY  Model2      6.4            51.47 TO    ET   Model1      6.2            12.54 TO    ET   Model2      6.8            10.54 OTT  KN   Model1      7.3            37.45 OTT  KN   Model2      7.3            39.14 OTT  VN   Model1      7.4            55.76 OTT  VN   Model2      7.6            58.76 OTT  PK   Model1      7.1            11.65 OTT  PK   Model2      7.2            15.67 WANT:                                      TO                             OTT                              SC     NY     ET          KN      VN       PK Model1  UN_rt       6.7      6.4     6.2          7.3      7.4       7.1  Model2  UN_rt       6.4      6.4     6.8          7.3      7.6       7.2 Model1  Price      34.56   56.77  12.54      37.45   55.76    11.65 Model2  Price      56.77   51.47  10.54      39.14   58.76    15.67 Part 2, I want to correlate the subgroups (SC, NY and ET) within TO if there are any corrlations.  And same within the OTT group. As an example, something like : Group1 (SC+NY) Group2 (ET) Group3 (KN+PK) Group4 (VN) ... View more