I have data that looks like this:
Subject Visit Test Value
1 1 1 100
1 2 1 75
1 3 1 110
1 1 2 12
1 2 2 11
1 3 2 9
2 1 1 125
2 2 1 128
....
I want it to look like
Subject Visit Test1 Test2
1 1 100 12
1 2 75 11
1 3 110 9
2 1 125 15
2 2 128 13
I want to keep the Subject and Visit and pivot Test and Value using pivot_wide
.