Matching and moving columns based on day number

[jillieroo]

I am posting this in this forum as I am unsure whether a function or macro is needed for my problem. If you could help me with the problem or direct me to where it would be better posted, I would really appreciate it.

I have daily observations which are daily, and model predictions which will have two values if there was rainfall on that day.

I have been manually moving all observations to match the date with the first of the two values. I have been doing this based on day numbers. If you look below you can see my dilemma (Although between 6962 and 6962 (and all other number matches) there are 20 or so columns of data which need to be moved along with the day number and date on the left).

The upper half I have moved manually, but the simulation extends over a hundred years and I do not have days and days to move tens of thousands of cells with copy paste. Does anyone know how I can automate this process?

24/01/1908 6962 6962
6962.0536
25/01/1908 6963 6963
26/01/1908 6964 6964
6964.0419
27/01/1908 6965 6965
6965.222
28/01/1908 6966 6966
6966.0382
29/01/1908 6967 6967
6967.0652
30/01/1908 6968 6968
31/01/1908 6969 6968.1405
1/02/1908 6970 6969
2/02/1908 6971 6969.0621
3/02/1908 6972 6970
4/02/1908 6973 6970.1454
5/02/1908 6974 6971
6/02/1908 6975 6971.0787
7/02/1908 6976 6972

[:) Sixthsense :)]

Please show it in excel with expected output for better understanding

[jillieroo]

Sorry it took me so long to reply, I had to change how I saved the files to keep them under the file attachment limit, I hope these help also What information may be lacking from that is Day#0 is 1889 – but excel doesn’t like pre-1900 dates, so day 4018 is 01/01/1900 and 4019 is 02/01/1900 and so on and so forth