I have a column (call it A) in Excel lists off different items and their properties. Every item has the word "Type" associated with it and so there is a cell with that label in column A so that in the column beside it (B) the type can be listed. Some (not all) items also have a "Widget" label associated with them.
Since each item only has one "Type" label I would like to be able to do is have Excel search for the "Type" label and then check whether there is a "Widget" label BEFORE the next "Type" label, and if there is paste the value in column B adjacent to the "Type" label in another sheet. It would continue doing this until no more instances of the word "Type" were found. Is this something that's feasible to implement? To make the layout more clear a sample column is below. Note that the number of spaces between each entry, unfortunately, is not consistent and so cannot be used as a way to track where one is. Similarly, the word Widget does not have to be directly above Type, it can appear anywhere between the two instances of "Type" that bookend it.
**Type** 01 Width .5 Length .4 Height .3 Weight 15 Widget Blue **Type** 072 Width .1 Length .1 Height .1 Weight 50 **Type** 025 Width .4 Length .4 Widget Red Weight 11 Height .4
The desired output on the separate sheet would then simply be:
since those are the types that have a widget associated.