chose the right data!

hi

I am tryin to automate something

where there is a label and it choses the data depending on that data, BUT if that data is consisted of more than 1 data, it needs to follow up with the data necessary.

example: COL A "fruits" COL B needs to say "apples" COL C "Pears

another example: COL A "Car Type" COL B "Brand" COL C should say "4 door" Col D "Toyota" Col E "Mazda" Col F "Benz"

attached is a small factor of what is needed, the numbers take priority over letters, so if the data label is CARs the data output would be CARs 1 vs over CARs A

Thanks all!