Hi there
I am analyzing SNPs from two different datasets that once collated will provide a complete picture of haplotype blocks. The issue I am facing here is there are SNPs that are found in both datasets and when I try to sort the collated file I can see duplication of these. Is there an easy way to collate the info into one row in excel like writing a code or something? Really need help from a computation biologist here!
So, If i got it right you are trying to remove duplicates from your file.
The solution in excel can be found here :
https://support.office.com/en-us/article/Filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2
There is a specific option for removing duplicates. To be honest, a command-line approach would be the best option here.
Daniele
- Badges
- Science topic
- Similar topics
- Bioinformatics
- Bioinformatics and Computational Biology