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?
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?
