Hello,
Just wanna ask, what is the best way to achieved this kind of Item No sequence based on the value of Item.
Just wanna ask, what is the best way to achieved this kind of Item No sequence based on the value of Item.
| Item No | Code1 | Item | Country |
1 | CA | CA8 | AT1 |
2 | CA | CA8 | BE1 |
3 | CA | CA8 | CN1 |
4 | CA | CA8 | CNB3 |
1 | GL | GL302 | AT1 |
2 | GL | GL302 | BE1 |
3 | GL | GL302 | CNB3 |
4 | GL | GL302 | CNDD |
5 | GL | GL302 | CZ1 |
6 | GL | GL302 | FR1 |
7 | GL | GL302 | GB1 |
8 | GL | GL302 | HKTCP1 |
9 | GL | GL302 | MY1 |
1 | GL | GL353 | AT1 |
2 | GL | GL353 | BE1 |
3 | GL | GL353 | CNB3 |
4 | GL | GL353 | CNDD |
1 | US | US138 | HK1 |
2 | US | US138 | HKDD |
3 | US | US138 | HKTCP1 |
4 | US | US138 | HKTT |
5 | US | US138 | HU1 |
6 | US | US138 | IN1 |
7 | US | US138 | IT1 |
8 | US | US138 | JP1 |
9 | US | US138 | KR1 |
10 | US | US138 | KWAI CHUNG |
11 | US | US138 | MX1 |
12 | US | US138 | MY1 |
13 | US | US138 | MY10 |
14 | US | US138 | MY11 |
15 | US | US138 | MYDD |
16 | US | US138 | NL1 |
17 | US | US138 | NLDD |
18 | US | US138 | PH1 |
19 | US | US138 | PHDD |
20 | US | US138 | PHTT |
21 | US | US138 | RO1 |
22 | US | US138 | SE1 |
23 | US | US138 | SG1 |
24 | US | US138 | TH1 |
1 | US | US139 | AT1 |
2 | US | US139 | BE1 |
3 | US | US139 | BR1 |
4 | US | US139 | CA1 |
5 | US | US139 | CN1 |
6 | US | US139 | CNB3 |
7 | US | US139 | CNDD |
8 | US | US139 | CNSGMT |
1 | US | US142 | AT1 |
2 | US | US142 | BE1 |
3 | US | US142 | CN1 |
