Hello,
I have data that is in sequential order. One column contains data that is either 1 or 0. I want to create a new column that numbers the groups of consecutive 1's.
<tbody>
</tbody>
What is the best way to generate column B if given data like in column A?
Any help is appreciated,
SAMARS
I have data that is in sequential order. One column contains data that is either 1 or 0. I want to create a new column that numbers the groups of consecutive 1's.
1 | 1 |
1 | 1 |
0 | |
0 | |
1 | 2 |
1 | 2 |
1 | 2 |
0 | |
1 | 3 |
1 | 3 |
0 | |
0 | |
0 | |
1 | 4 |
1 | 4 |
<tbody>
</tbody>
What is the best way to generate column B if given data like in column A?
Any help is appreciated,
SAMARS