How to transpose table

I Have tried Transpose and CrossTab, but I could not get what I am looking for,

How can you rotate a table that the orientation is transposed?

Eg :I have table with 4 Columns

Col1 Col2 Col3 Col 4

Var1 2 AB 1

Var2 3 AB 1

Var3 1.2 AB 1

Var2 5 BC 2

Var3 6 BC 2

Var4 2 BC 2

How can I turn it into:

Col3 Col4 Var1 Var2 Var3 Var4

AB 1 2 3 1.2 -

BC 2 - 5 6 2

I have tried the options with transpose and crosstab, but could not get the result.

Accepted answers

This approach is the easiest alternative (see attached)

This should give you what you need for the data provided.

Just check that the sum tool - "min" criteria will meet the requirements for your larger data set.

Regards,

Aidan

This approach is the easiest alternative (see attached)