I need to make a report showing groups of issues by Category (6, columns) and Status (3, rows). It would look like a pivot chart only with data in the cells instead of counts of items. The multiple data items must be concatenated in the cells. Some cells may be empty. Example:

C1 C2 C3 C4 C5 C6

S1 Data Data Data Data Data

S2 Data Data Data Data Data

S3 Data Data Data Data Data

I use Access 2000 on XP. The query, if it matters, draws the results from an Oracle database.