Good afternoon all, hope all is well today. I have one column with ten-thousand rows of data. I need to extract all the even numbered rows and move it into column B. Furthermore, both columns need to shrink to 50 rows. How can I accomplish this faster without manually cutting and pasting?
Notes: All odd numbered rows begin with "C", all even numbered rows begin with any number between "0-9".
Thanks! Have a great day.
Notes: All odd numbered rows begin with "C", all even numbered rows begin with any number between "0-9".
Thanks! Have a great day.