Forum Discussion
Count Occurrence with Index
Hello I am working with a limited data set. I need to create a grouped index and my thought was to count each occurnace and fill down thereby giving me set or groups to work with. In my table be...
Hello Works great when we have a set number between each row. Now in this eaxmple beow there is no set number. The row sequence is the same "Show" then flights and "Debrief". There could be multiple flights. So, the set number is not always the same. The end Goal is to merge (join) the one set of days with the other. But your solution does with with a set number
DayFlightDeparture-Arrival
| Show Time | ||
| 15Jun Tu | K4 807 | CVG-BAH |
| Debriefing | ||
| Show Time | ||
| 17Jun Th | K4 807 | BAH-HKG |
| 18Jun Fr | K4 860 | HKG-NGO |
| Debriefing | ||
| Show Time | ||
| 19Jun Sa | K4 258 | NGO-LAX |
| Debriefing | ||
| Show Time | ||
| 20Jun Su | K4 232 | LAX-SYD |
| Debriefing | ||
| Show Time | ||
| 24Jun Th | K4 259 | SYD-SIN |
| Debriefing | ||
| Show Time | ||
| 25Jun Fr | K4 259 | SIN-HKG |
| 26Jun Sa | K4 258 | HKG-NGO |
| Debriefing |