I am trying to setup a query or formula that will read through one data field which has different data in it. The data in MySQL looks something like the following:

Record No. | Field Name | Field Type | Field Value
-------------------------------------------------------
1 | Prob_ID | Int | 2000
1 | Status | Text | Closed
1 | Sec_ID | Int | 12
2 | Prob_ID | Int | 2000
2 | Status | Text | Open
2 | Sec_ID | Int | 22
3 | Prob_ID | Int | 2005
...


I need to be able to group by Prob_ID and then by Sec_ID and then list all the related statuses underneath it. In other words, I need something like:

Prob_ID 2000
Sec_ID 12
..... 1 Status Closed
Sec_ID 22
..... 2 Status Open
Prob_ID 2005
Sec_ID ...
Sec_ID ...


Can anyone tell me how I can do this?

Thanks,
SB