Creating group subdivisions using calculated columns

 

Suppose I wanted to create a culculated column that subdivides an initial column. The initial column aleady shows groups labeled as 1, 2, 3 etc with 0's seperating those groups. The calculated column would then simply subdivide the initial groups by a set integer, say 3, as in the below example. Is there a way to do this?

Initial Column Calculated Column
0  
1 1
1 1
1 1
1 2
0  
0  
2 3
2 3
0  
0  
3 4
3 4
3 4
3 5
3 5
3 5
3 6
0  
4 7

Thanks!

(1) Answer

Login