Missing Date Fix

Question

Hi There....

Can anyone help with this request...I have region data and everyone if a sale takes place then 1 shows in the month...as shown below

but what i need is.....for each region go to the first month where 1 shows and fill in missing 1's for each subsequent month and include the current month to give this.....i really just need all the yellow blank months filled in with 1 as shown below.....

.....as you can see the current month Jan-24 is empty in the before pic, and if current month is empty then i need it to be included and marked as 1...

Sample Data Excel attached....any help would be great :)

Dates Before.png

Region Date Fix.xlsx

Gawa · Accepted Answer

hi @DelData

Please try the attached WF.

Trick herein is "cross-tab and transpose in a row. By doing so, you can have the data like below so you ca easily replace Null with 1 by Multi-row formula at downstream.

DelData · Accepted Answer

Thank you....this works and really has helped me fix a question i had some problems with....thank you 😀