Missing Date Fix
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 :)
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you....this works and really has helped me fix a question i had some problems with....thank you 😀