Hi,
I have 2 columns with data:
See example picture.
This is an example of 30 lines for column A/B, but the amount of rows and the amount of TRUE/FALSE values may differ
So the amount of [D] Start CH and [E] End CH rows also may differ
How do I do this in Excel?
I have 2 columns with data:
- Column A has chainage (CH) values, which are ascending consecutive numbers, and not always start with chainage 1
- Column B has FALSE/TRUE values
See example picture.
This is an example of 30 lines for column A/B, but the amount of rows and the amount of TRUE/FALSE values may differ
So the amount of [D] Start CH and [E] End CH rows also may differ
How do I do this in Excel?