Hello all,
I have a list of dates in Column A.
The first 3 years are month by month.
The next 3 years are then quarter by quarter.
From there on the dates are annual.
I need to get this into a sheet which has column A as continuous monthly dates and then values for each month. If the date was a year in the source sheet, then the final sheet should simply have this value divided by 12.
Excel sample 1.JPG
Thanks for the help
Bookmarks