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 …
just I copy the whole row how could be when import from the file .
each item is in existed in column . 31 is in existed in column SR
QTY ORIGIN MARK BRAND SR
450 N/A BRIDGESTONE BS 650R16 R230 JAP 31