I have about 100 files of MS Excel which consist of weather data.
I need the data on yearly basis but the file has a single column with data of about 140 years and manually copy-paste is very time consuming. So, is there any way to split the data by using simple commands which can be dragged so that data of 1 years(365 cells) is copied in continuous rows.
Also, there is the leap year problem that data after every 3 years should be 366 cells instead of the rest 365 cells.