Cross tab for multiple columns

[Hong_Hu]

Hi all,

I have a data set that looks like this:

rank name outcome

1 A accepted

2 B rejected

I would like to transform it to:

Name1 Name2 Outcome1 Outcome2

A B accepted rejected

Is that possible with crosstab? Thanks!

[martinson · Accepted solution]

Hi @Hong_Hu I have attached a solution for you. You must first use the transpose tool and then concatenate your Name column in order to get what you need from the crosstabs tool. Also, ensure that you are switching to a V or W string data type after the transpose as the normal string data type is too small.

Let me know if you have any other questions,

Cheers,

martinson

[Hong_Hu]

Yes, exactly what I need. thanks so much!