S
Sorting data
i am trying, unsuccessfullty, to sort some data (a small example is below) so
I can graph it. I want to put it into a pivot table format but don't want
calculations, just the actual data. any ideas??/
Location DATE Result
WAT002WA ALBANY BOTTOM 19-Jul-05 0.83
WAT002WA ALBANY BOTTOM 23-Jun-05 0.8
WAT002WA ALBANY BOTTOM 28-May-05 1.16
WAT002WA ALBANY BOTTOM 02-May-05 0.93
WAT002WA ALBANY BOTTOM 06-Apr-05 0.66
WAT002WA ALBANY BOTTOM 11-Mar-05 0.59
WAT002WA ALBANY BOTTOM 13-Feb-05 0.54
WAT002WA ALBANY BOTTOM 18-Jan-05 0.62
WAT002WA ALBANY TOP 09-Mar-07 0.73
WAT002WA ALBANY TOP 11-Feb-07 0.74
WAT002WA ALBANY TOP 16-Jan-07 0.67
WAT002WA ALBANY TOP 21-Dec-06 0.61
WAT002WA ALBANY TOP 25-Nov-06 0.7
WAT002WA ALBANY TOP 30-Oct-06 0.75
WAT002WA ALBANY TOP 04-Oct-06 0.74
I can graph it. I want to put it into a pivot table format but don't want
calculations, just the actual data. any ideas??/
Location DATE Result
WAT002WA ALBANY BOTTOM 19-Jul-05 0.83
WAT002WA ALBANY BOTTOM 23-Jun-05 0.8
WAT002WA ALBANY BOTTOM 28-May-05 1.16
WAT002WA ALBANY BOTTOM 02-May-05 0.93
WAT002WA ALBANY BOTTOM 06-Apr-05 0.66
WAT002WA ALBANY BOTTOM 11-Mar-05 0.59
WAT002WA ALBANY BOTTOM 13-Feb-05 0.54
WAT002WA ALBANY BOTTOM 18-Jan-05 0.62
WAT002WA ALBANY TOP 09-Mar-07 0.73
WAT002WA ALBANY TOP 11-Feb-07 0.74
WAT002WA ALBANY TOP 16-Jan-07 0.67
WAT002WA ALBANY TOP 21-Dec-06 0.61
WAT002WA ALBANY TOP 25-Nov-06 0.7
WAT002WA ALBANY TOP 30-Oct-06 0.75
WAT002WA ALBANY TOP 04-Oct-06 0.74