How to transpose table

[redsanjay]

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.

[Aidan_K]

Hi @redsanjay 

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

[Aidan_K · Accepted solution]

Hi @redsanjay 

This approach is the easiest alternative (see attached)

[redsanjay]

you are awesome, works perfect..!!

Thank you Very much

[Aidan_K]

Your welcome, happy to help :)

Aidan