Hi all,
In a bit of a pickle. Basically I am trying to find a way to convert my dataset from a weekly format into a monthly format, however am having issues with the fact that my data goes on a week commencing basis (take for example wc. 30/12/19 - I only want 2/7ths of my data to fall into a Dec-19 range and 5/7ths into a Jan-20 range).
I have attached a test file which illustrates what I am working with - values by region.
Any help anyone could offer would be greatly appreciated (please no pivot-table 'group by' instructions - it doesn't work for the purposes of this I don't think).
Best,
C
Bookmarks