make a good cup of coffee is all i can suggest! Sadly that is what I had to do.
I firstly set up a column to number each day, so 48 no. 1s then 48 no. 2s etc then copy and pasted the transpose function down changing the array for each day using the first coloumn as a reference.
I am almost certain there is a better way to do this, but it hasn't come to me yet.
Sorry I don't have the magic solution! yet.