organizing Column A, eliminating repeats, and transferring them to Columns B to xxxxx.....

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!!!

That's so true. Here's a mock up of the original data and final desired outcome.

excel forum.xlsx

wow. Quite beyond my skills. Still not quite sure how to automate it. One of the biggest hurdles is getting SNP names from Column A to Columns B through XXXXX (in the original dataset, there are thousands of rows, but only a few hundred unique SNP names.

So is the suggestion to eliminate duplicates, then transpose them, and THEN run your impressive formula? Because you obviously just copied and pasted the SNP name at the top of Column B, C, and D, correct? That task wouldn't be feasible with several thousand lines (most of which are repetitive, I think every 400 or so ID, the SNP name becomes a new name. So there needs to be a way to copy and paste AND reference AND tally the data in Columns A, B, C (from the original data).

Your method is definitely a step above anything I could have come up with. I'm going to play around with the data some more.

I appreciate the assistance a ton!