So I don't know how quite to phrase the question. I think it's best to show with screen shots
original data.JPG
final data.jpg

In the "original data" - obviously shorted for this question. You have Column A, which is a couple thousand rows long, but contains about 40 unique values. In Columns B you have your ID of interest. In Column C you have your genes.

I want to reorganize Column A, such that every unique value is only represented once, and now occupies all of the columns. See "final data."

So basically from the "original data," every CAP_001 with AA is placed under Column rs10037809. Every CAP_001 with TT is placed under Column rs10120572, and so on.

To me, this doesn't seem possible in Excel. Any opinions? Thoughts on how this can be done without tedious cutting and pasting?

I appreciate it!!!