Long term data into single column

Hi all,

I have long term flow daily data ( months in rows i.e 12 rows and 31 days in columns) for 50 years. There is empty row after each year data. Is it possible to rearrange data into 2 columns? Ist column will show date from 1/1/1960 to 31/12/2017 whereas 2nd column will show data for each date.

I am looking to find micro for this work

Thank you.

Saleem

Please find attached sample excel sheet.

Thank you.

Thank you very much. It worked for my data. Great.

Could you please guide me for another code that is about to convert daily data ( obtained from above code into two columsn, 1st showing date and 2nd showing data) into 10 daily data for long term series.

Kind regards,
Saleem