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

Dear NBVC

Thanks v much, certainly solves the problem

Two small questions
1) When there isn't a match ie there are no results in 6 but were in 6, the value #N/A is inserted. Is there a way to insert N/A without the # or some other text all at the same time or is it easier to just do a Find and Replace

2) Can you either provide a brief explanation of your code using INDEX and MATCH or can you point me somwhere I can get a good explanation

Once again thanks v much
Steve