I have run out of talent in Excel.
I have one column that has multiple elements separated by a slash, eg one/three/five/seven and I need to break that single column into multiple columns BUT I need that breakup to happen in a specific way - one needs to go into column 1, three into column 3, etc. Like:
Original A B C D E F G H 1/3/5/7 1 3 5 7 2/4/6/8 2 4 6 8
Any ideas?