I have below data set and I want to transpose two variables at the same time “Score” and “Grade”.
Input Data Set:
ID Score Grade
A 9 A
A 5 B
B 8 A
B 3 C
I want to transpose it as follows:
ID Score1 Score2 Grade1 Grade2 A 9 5 A B B 8 3 A C
Currently, I’m transposing one variable at a time and then merging the two data sets. Could this be done in one step?