Hello,
I have more than 1,000 .csv files (sample attached) with thousands of records in each (not fixed duration, and here i made it shorter).THIS IMAGE IS MY DESIRED OUTPUT. desired output1.png
1. I need to split date to YEAR/MONTH/DAY (in 3 columns). While the cell format is MDY, so I tried to change the format of date column to DMY first.
But the problem is, the cell format is different and the pattern is repeated for the next years. (pls see the image)
2. After splitting, how can I delete the reference DATE column, while I am using YEAR/MONTH/DAY functions? (because i don't need it anymore)
Thank you in advance
Bookmarks