Hello,
I managed to copy and paste some stock prices into Excel but I need to delete a few columns and the problem is that the format does not allow me to separate whats in one column.
For example, the data I have is as follows in 3 columns:
YYYY MM DD value | YYYY MM DD value| YYYY MM DD value
The YYYY MM DD is the same date on one line and the "value" are actual numbers but what I want to do is simply have one column that contains the date followed by value,value,value. How do I segregrate the YYYY MM DD so that I can delete the columns?
Any help would be appreciated,
Thanks,
Al
I managed to copy and paste some stock prices into Excel but I need to delete a few columns and the problem is that the format does not allow me to separate whats in one column.
For example, the data I have is as follows in 3 columns:
YYYY MM DD value | YYYY MM DD value| YYYY MM DD value
The YYYY MM DD is the same date on one line and the "value" are actual numbers but what I want to do is simply have one column that contains the date followed by value,value,value. How do I segregrate the YYYY MM DD so that I can delete the columns?
Any help would be appreciated,
Thanks,
Al