Forum Discussion
Repeating dates based on row criteria
Hi all, Hoping someone can help me. So basically I have this survey dataset (see sample below). The Walk Date column doesn't actually exists in the original dataset, however it exists as one of ...
Can you just right-click on the Walk Date columnj Anonymous , select Fill from the right-click menu, then Down from the submenu?
It will fill the date down filling all nulls until it hits another date, then it stops and repeats the process.
Hi edhans,
Unfortunately, some locations have more than the 2 questions. Thanks for the suggestion. So when I do fill up/fill down (or both), it would sometimes put the incorrect date for at the start of the new task ID. This is my dilemma. See the screenshot below. Any other suggestions?
Hi edhans,
I was able to find a solution. What I did was filtered the question Walk Date which would remove the date discrepancy between the unique Task ID when I do the fill down. Thanks for your help!