Create Group ID Based on Null Row

[andrewplaice]

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!

[atcodedog05 · Accepted solution]

Hi @andrewplaice 

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 😀👍

[andrewplaice]

Thanks much!

[atcodedog05]

Happy to help 🙂 @andrewplaice 

Cheers and Happy Analyzing 😀