Hello all,
I am having a hard time extracting rows above rows designated with an asterisk, and then looping this action so that I can assign every piece of data to a number. For instance, the first rows above *FIFO should be extracted until it meets the row *COGS with an asterisk and all should be designated as 1 (in a new field), then the next set of rows until it meets *R&D should be designated as 2, and so on. In the larger data set, (not here but similar to the one posted) there are a variable amount of rows in between the rows designated with an asterisk. Additionally, is there a way to only target between rows with ONE asterisk? As there may be rows that have more than one asterisk. I would like to do this loop until the entire data set has been parsed.