Hi - I'm trying to use the Multi-Row Formula tool to add an ID number to a set of records (the data will eventually be cross-tabbed, as the values will need to become the field names). The challenge is that there is a different number of rows to group for each ID. So using a standard +/- number of rows does not work, as each grouping could have a various number of rows in the raw data. Essentially what I'd like to do is assign an ID number to all rows from where the value is "First Name" down through the last row prior to the next one with a value of "First Name". Sample data is included in the attached workflow.
Thanks!
