I need to get data that is organized in rows so that I can view it in columns. I have data that take this form:

P1 | progA | T1 | 23

P1 | progB | T1 | 31

P1 | progA | T2 | 25

P1 | progB | T2 | 39

P2 | progA | T1 | 10

P2 | progB | T1 | 33

P2 | progA | T2 | 19

P2 | progB | T2 | 32

... and so on from P1 to P2000. The fourth column is populated by scores at time-periods T1 and T2 for two different tests (progA and progB).

I need to report on it so it looks like this:

P1 | T1 | T2

progA | 23 | 25

progB | 31 | 39

... and so on. Do I need to create a T1 and a T2 column in my data and populate it using a script of some kind? Or is there a layout or portal feature that will get me what I want? I can't get it to work no matter what I do.

Thanks for any help you can provide.

BR

think you may want to review this...

http://www.nightwing.com.au/FileMaker/demos8/demo801.html

This is good stuff - but my data aren't actually pipe delimited (I'm sorry if that was confusing in my original post). They are filemaker data. I just used the pipes to illustrate where the columns were in the data. So, what I have is data that are in a one-record-per-score format, and I need to report on them with a column for each time-period. Is there an easier way?

Any other ideas?