I am copying and pasting a list of text values and numbers. The text values are on top, and their corresponding numeric values are on bottom:
Three
Two
One
3
2
1
While leaving the original column of data as is, I need to create range that references the original but separates the text and numeric values into two different columns. The final product should look something like:
Three
Two
One
3
2
1
Three 3
Two 2
One 1
Bookmarks