Transverse data

Question

[Sidra]

We have transposed our data according to our requirement. that is also attached in this post. now we have duplicate words in each cell of our output file. please suggest me any unix, python, rstudio or excel based tool to remove these duplicates within a single attempt because we have a huge data of 1510 isolates and we cannot delete duplicates one by one from each cell.

DATA:

aminocoumarin   aminoglycoside  carbapenam  cephalosporin   cephamycin  fluoroquinolone glycylcycline   macrolide   monobactam  nitroimidazole  penam   peptide phenicol    rifamycin   tetracycline    triclosan
aminocoumarin   aminoglycoside  carbapenam  cephalosporin   cephamycin  fluoroquinolone glycylcycline   macrolide   monobactam  nitroimidazole  penam   peptide phenicol    rifamycin   tetracycline    triclosan
aminocoumarin   aminoglycoside  peptide fluoroquinolone macrolide   penam   carbapenam  cephalosporin   cephamycin  glycylcycline   monobactam  phenicol    rifamycin   tetracycline    triclosan   nitroimidazole

Answer 1

[mohammadhassanj]

A Step-by-Step Guide on How to Remove Duplicates in Excel

Answer 2

[basu]

Sounds like you’ve got a data party going on—too many duplicates crashing it! If you need a quick fix for those pesky repeats, maybe check out this tool that handles duplicates in Excel like a champ. Just saying, it could save you some sanity! Remove Duplicates Excel https://removeduplicatesexcel.net