Hi all,
Likely easy for you, not so much for me. I am trying to create a sequential group ID for rows of data. My data can look something like this (number of rows and data values will vary, but are numeric):
Data
1
1
1
[Null]
4
4
[Null]
1
1
[Null]
And I would like to create a group value that groups data above the null:
Group Data
1 1
1 1
1 1
[Null]
2 4
2 4
[Null]
3 1
3 1
Appreciate your help as always!
Solved! Go to Solution.
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Thanks much!