I have a data file made up of 3 columns, 17520 rows consisting of date, half hour increments of time and a value against each half hour (this is for a years worth of data)
I need the data to be in 365 rows (one for each day) and 48 columns (one for each half hour of the day)
Is there a function in excel to transpose / sort the data into this format?
I need the data to be in 365 rows (one for each day) and 48 columns (one for each half hour of the day)
Is there a function in excel to transpose / sort the data into this format?