I have a cursor that contains data like this:

Type Field001 Field002 Field003 Field004 Field005
AAA  11111111 55555555 XXXXXXXX          99999999
BBB  22222222 DDDDDDDD 77777777 PPPPPPPP 88888888

Then a lookup table that is organized like this:

Type FieldName Description
AAA  Field001  AAA1
AAA  Field002  AAA2
AAA  Field003  AAA3
AAA  Field004  AAA4
AAA  Field005  AAA5
BBB  Field001  BBB1
BBB  Field002  BBB2
BBB  Field003  BBB3
BBB  Field004  BBB4
BBB  Field005  BBB5

I loop through and use those to get this cursor:

Type FieldName Value    Description
AAA  Field001  11111111 AAA1
AAA  Field002  55555555 AAA2
AAA  Field003  XXXXXXXX AAA3
AAA  Field005  99999999 AAA5
BBB  Field001  22222222 BBB1
BBB  Field002  DDDDDDDD BBB2
BBB  Field003  77777777 BBB3
BBB  Field004  PPPPPPPP BBB4
BBB  Field005  88888888 BBB5

The fields, rows, etc. are more involved than that simple example, but hopefully this is enough to get me through the logic of the next part.

I think I need to take the result, or manipulate the process while I'm creating the result, to get each type (AAA or BBB) into 1 row each in such a way as to make logical sense when displaying to the user. I say "I think" because Field001 for Type AAA has no relationship to Field001 for type BBB. I wonder if I should even be looking at it in this way. There is going to be a cursor in a grid somehow that the user will move through by Type and then be able to see the relevent information associated with it. I can't seem to think how to twist this around to do this, or if I even need to twist it. Any ideas?