Hi everyone, I am working with some SNPs analisys/filtering and came across with a challeging task. After filtering for the alterations of interest, I got a file with the follwoing configuration:
01_126729_C
01_85829_G
02_11867_A
02_171665_C
02_183470_A,T
03_225197_G
03_360822_T
03_364428_T
03_51665_C
03_66720_A
In which 01_, 02_, ... represent chromosomes. I need to split this single column into multiple columns, containing only the SNPs from one chromossome per column. I don have a clue on how to do this! Could anyone please help me with this? That would save me a lot of boring work on excel!
Cheers!