Hi to all
i would like to extract letters from text and paste them in new rows one below the other. my data looks like this
My data
1 2 3 4 5
1 A/C A/A G/G C/C T/T
2 A/A T/T A/C T/C G/C
and i would like to do like this
expected
1 A A G C T
1 C A G C T
2 A T A T G
2 A T C C C
I used trim and substitute functions but i am unable to complete my task. I am requesting help fro you people. your help will always be appreciated
Thanks in advance
Bookmarks