Search for variables if not there add lines to file macro

[penbeacho]

I am trying to search through some data that I have formatted to a certain point from its original form. I am kind of stumped, I cant figure out how to get excel to search for a specific set of terms, if a term is not found, then id like to add it above the previous term. This list would always have the initial variable there its the other variables that would change. I have attached and example file first sheet shows how it would look when starting, the second sheet how it would look when done. In the given example I could do this manual but for the actual file there is too many data points that may lead to error and alot of time.

my final goal after this is done is to take the rage of data for each code and eventually transpose it into a formatted table

Hope someone can help.