I have school level data with the name of different counties they have belonged to across a number of years. Each year has a column for each school, some are missing, some schools might fall into different counties.

1. I want to check how many schools have consistent counties over the year (ignoring any . (missing) values).
2. If schools have consistent counties I want to merge all these 10-15 variables into one giving me the county name if no conflict, and returning "conflict" when conflict, . if data is just missing.

Screenshot is attached.

Array