Crosstab - Making column data to row data

[khexcel]

I have unique date like this (2 columns type and class):
Type Class
A 1
A 2
A 3
B 1
C 1
C 2
D 1

And I want to display like this (multiple columns, 1 with type and others with class):

Type Class1 Class2 Class3 Class4...
A 1 2 3
B 1
C 1 2
D 1

I do not know the number of classes but want access to automatically name the column. It's like a pivot table but instead of summarizing the class data, I want to display the actually value (class). Can someone help?

 

[Norie]

First create this query:

SELECT Sheet1.Type, Sheet1.Class, "Class" & [Class] AS ClassType
FROM Sheet1;

Replacing Sheet1 with your table name.

Then create this crosstab query:

TRANSFORM Max(Query1.Class) AS MaxOfClass
SELECT Query1.Type
FROM Query1
GROUP BY Query1.Type
PIVOT Query1.ClassType;

I tested it using your data and it seems to do what you want.