I have a column with protease sequece. It is a big text string. For example
if GTAGAGCTGT is in one column, Starting from every letter, 5 letter should be created and it should be split like below and separate columns should be created
Column1 Column2 Column3 Column4 Column5 Column6
GTAGA TAGAG AGAGC GAGCT AGCTG GCTGT
Please help. I am attaching the excel file and I have highlighted the text column in yellow. The new columns should be created on the right side of the existing data.
Bookmarks