Hi,
Can someone please help me? I'm in a real bind
I have 100 years of monthly datat that I want to compare to 100 years of daily data. Is there any way of automatically adding for example another 30 rows to January 1900 and pasting the values for January into each row and so on and so forth for the other 11 months?
I know there'a a fair bit on compressing data into monthly from daily but obviously not much the other way round so any help would be very very much appreciated.

Thanks