Data arrangement

[akumagaavese]

Dear all,
I need help to arrange my data. I have rainfall data that is arranged year by year as you can see the attached in the sheet named data and I want it to be arrange in a continuous column from year 1 to the end as you can see in the sheet named format. Thanks for your help.

[dosydos]

Here you go.
I had to add a new column A on the "Format" Sheet for the formula to work.

Data_arrangement_formula.xlsx

[akumagaavese]

Thank you so much. it works very perfect

[dosydos]

you're welcome