Hi,
I want to sort random data into text and numbers. I have over 25000 rows of this type of data. I have attached the sample sheet for better understanding. Please note that I have shown the sample input raw data that i have and output data that I want to get from input data.
Please share a way to sort this data by using a formula or macro.
Thanks in advance for your kind support.
Younas
I want to sort random data into text and numbers. I have over 25000 rows of this type of data. I have attached the sample sheet for better understanding. Please note that I have shown the sample input raw data that i have and output data that I want to get from input data.
Please share a way to sort this data by using a formula or macro.
Thanks in advance for your kind support.
Younas