What is the rule to follow in such case ? Do nothing, not compare ORIGIN & BRAND so BRAND stays as it is ?
the rule when the adjacent cell for last item contains JAP for N/A cell then keep the last item JAP
if you see that is not sense , then I will clear N/A manually and write JAPAN and finish this problem.
so what you think?