hi,working on google excel, how would i go about finding a set word in a cell, then once found the word get the word above it, then put that word into a cell but the word i search for would have multiple the same and would need to get the data above each word found and add that to a new cell each time found

Example

https://docs.google.com/spreadsheets...it?usp=sharing

thanks Ditch