If I well understood N/A can't exist in the real data ? If so then it could be a direct new green light but as you wrote

Quote Originally Posted by abdo meghari View Post
when import data will be in excel like this
450 N/A BRIDGESTONE BS 650R16 R230 JAP 31
so the the last item should not add any thing because JAP is existed
New issue here as JAP is not the last item ‼
So according to the rules JAP is added after 31 so the final result is 450 N/A BRIDGESTONE BS 650R16 R230 JAP 31 JAP