Given data: Date Company 20150101 Comp1 20150201 Comp2 20140301 Comp3..... Desired output: YYYY MM DD Company 2015 01 01 Comp1 2015 02 01 Comp2 2014 03 01 Comp3..... Its an excel file with 10000 data sets. What code will transform the given data into desired output?
... View more