Pivot Table Problem

Dear list

I have attached a Excel 2003 spreadsheet which has data in columns A...F.

Col B and C are evaluated with multiple IF's and the results placed in E and F.

Ultimately there will be data from rounds 1...6 and I have only shown Rounds 5 & 6 in the sample attached. I have hand assembled the data in yellow and purple into the green area.

I can use a PIVOT TABLE to accomplish the sorting as per the green shaded data BUT can't get the actual col data into the table - a function of how the pivot works.

My question is can someone suggest how a PIVOT TABLE can be constructed which does not count/sum..etc the data, since that would seem to solve the problem.

Any suggestions / ideas as to how this could be solved would be appreciated.

Steve