How do I get the lower- and upper-bound range(s) of the following data for each set of “1s”:
| LogFileTextID | ErrorLineFlag |
|---|---|
| 88182351 | 0 |
| 88182352 | 0 |
| 88182353 | 0 |
| 88182354 | 0 |
| 88182355 | 1 |
| 88182356 | 1 |
| 88182357 | 0 |
| 88182358 | 1 |
| 88182359 | 1 |
| 88182360 | 1 |
| 88182361 | 1 |
| 88182362 | 1 |
| 88182363 | 1 |
| 88182364 | 1 |
| 88182365 | 1 |
| 88182366 | 1 |
| 88182367 | 1 |
| 88182368 | 1 |
| 88182369 | 1 |
| 88182370 | 1 |
| 88182371 | 1 |
| 88182372 | 1 |
| 88182373 | 0 |
| 88182374 | 0 |
| 88182375 | 0 |
| 88182376 | 0 |
| 88182377 | 0 |
| 88182378 | 0 |
| 88182379 | 0 |
| 88182380 | 0 |
I am expecting the following:
| InstanceNum | LowerID | UpperID |
|---|---|---|
| 1 | 88182351 | |
| 2 | 88182352 | |
| 3 | 88182353 | |
| 4 | 88182354 | |
| 5 | 88182355 | 88182356 |
| 6 | 88182357 | |
| 7 | 88182358 | 88182372 |
| 8 | 88182373 | |
| 9 | 88182374 | |
| 10 | 88182375 | |
| 11 | 88182376 | |
| 12 | 88182377 | |
| 13 | 88182378 | |
| 14 | 88182379 | |
| 15 | 88182380 |
Is this possible?
1