I have a data set that looks like the following.
ID Rank Text
a 1 Text1a
a 2 Text2a
a 3 Text3a
b 1 Text1b
b 2 Text2b
I would like the results to look like this:
I am unsure where to begin. Any help would be appreciated.