How to separating text in cell into separate columns?

[genetist]

HI to all
i have data some data like A/T in a column i would like to split into A in one column and T in adjacent column. I tried with this code but this code is not separating duplicates i mean if A/A in first column and 2nd column it is separating A/A in 1st column only. please check attached file for better understanding of my problem.

Please Login or Register  to view this content.

Thanking you very much for your help and any help in this regard will be highly appreciated

[alansidman]

employing power query, here is the Mcode

Please Login or Register  to view this content.

[Glenn Kennedy]

or... just for fun (I'm bored...) using a formula:

=MID(INDEX($A3:$C3,1+INT((COLUMNS($A:A)-1)/2)),CHOOSE(1+MOD((COLUMNS($A:A)-1),2),1,3),1)

copy across and down.

[jindon]

For the data uploaded

Please Login or Register  to view this content.

[genetist]

Thanks jindon for your help. Your suggestion working perfect as per my needs.

[jindon]

You are welcome.

If the 1st row is just a dummy header then delete the 1st row and change 2 to 1

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[genetist]

Thanks Jindon
I am getting some error here

Please Login or Register  to view this content.

i have more than 8000 columns and i tried to use this code and i got this error
run-time error:'1004'
application defined or object defined error
but this code is working with less number of columns

[jindon]

Number of columns are 16384, so you can have 8192 columns maximum.

Please Login or Register  to view this content.

[Rick Rothstein]

While I was creating this code and writing my response, I see you posted that you have need to processes way more columns than my code would be able to handle, so you can ignore what is below.

If you are interested, here is a slightly more compact macro which only uses a single loop to do what you asked for...

Please Login or Register  to view this content.