As you can see in the screenshot and the worksheet I attached, I have a column with one string with 2 numbers on each row. I want to split to where the second number will move into a new column right next to the column it is on.
What I want to result to look like
SplitTest - Copy.xlsx (9.5 KB)
Please use Sheet2 for the final result