I need to combine multiple csv files into one worksheet of continuos record, in weekly chronological order and with a new label in column C and save it in an xls format. I have assembled the files in one folder. I am not that familiarised with the specialised functions of excel. I have excel 2010 for mac 2011. I need to submit this tomorrow ASAP.
Solved by X. S. in 30 mins