Spreadsheet: 692816d1598586571-extracting-data-from-another-sheet-exfo
Sheet: data

Order ID | [NAME] | Return / Refund Status | Parent SKU Reference No. | SKU Reference No. | Original Price | Deal Price | Quantity | Product Subtotal | [NAME] | [NAME] | [NAME] | SKU Total Weight | No of product in order
2008167ABJMTPF | Completed |  | 91-HL016 | 91-HL016-BK | 25.00 | 19.90 | 1 | 19.90 | 5.10 | 5.10 | 0.00 | 2.100 | 1
200808F2PXW8P9 | Completed |  | 36-0118D |  | 25.00 | 19.50 | 1 | 19.50 | 5.10 | 5.10 | 0.00 | 0.500 | 2
200808F2PXW8P9 | Completed |  | 36-0118N |  | 17.00 | 11.76 | 1 | 11.76 | 5.00 | 5.00 | 0.00 | 0.300 | 2
2008166UAYTJYF | Completed |  | 36-3173 |  | 22.00 | 19.90 | 1 | 19.90 | 2.10 | 2.10 | 0.00 | 0.400 | 1
2008167JN7HEPF | Completed |  | 36-AT288 | 36-AT288G-R | 35.00 | 29.90 | 1 | 29.90 | 5.10 | 5.10 | 0.00 | 0.500 | 1
2008155QVH4PHE | Completed |  | 36-238 | 238C | 15.00 | 7.90 | 1 | 7.90 | 7.10 | 7.10 | 0.00 | 0.200 | 5
2008155QVH4PHE | Completed |  | 36-238 | 238H | 15.00 | 7.90 | 1 | 7.90 | 7.10 | 7.10 | 0.00 | 0.200 | 5
2008155QVH4PHE | Completed |  | 36-GG-968 | 36-968-2 | 15.00 | 8.50 | 1 | 8.50 | 6.50 | 6.50 | 0.00 | 0.200 | 5
2008155QVH4PHE | Completed |  | 36-GG-968 | 36-968-8 | 15.00 | 8.50 | 1 | 8.50 | 6.50 | 6.50 | 0.00 | 0.200 | 5
2008155QVH4PHE | Completed |  | 36-GG-968 | 36-968-10 | 15.00 | 8.50 | 1 | 8.50 | 6.50 | 6.50 | 0.00 | 0.200 | 5
2008178RRE9D1D | Completed |  | 83-2142/2026/2139/2022 | 83-2139 | 2.20 | 1.99 | 10 | 19.90 | 2.10 | 2.10 | 0.00 | 1.000 | 13
2008178RRE9D1D | Completed |  | 93-YQ219 | 93-YQ219-B | 2.00 | 1.80 | 1 | 1.80 | 0.20 | 0.20 | 0.00 | 0.100 | 13
2008178RRE9D1D | Completed |  | 15-1132-1 |  | 7.00 | 6.30 | 1 | 6.30 | 0.70 | 0.70 | 0.00 | 0.100 | 13
2008178RRE9D1D | Completed |  | 15-1131-1 |  | 7.00 | 6.30 | 1 | 6.30 | 0.70 | 0.70 | 0.00 | 0.100 | 13
2008142E25CTNT | Completed |  | 36-88168-4S |  | 33.00 | 29.90 | 1 | 29.90 | 3.10 | 3.10 | 0.00 | 0.500 | 2
2008142E25CTNT | Completed |  | 36-2016-5A/2017-5A/2017-6A/2017-7A | 36-2017-7A | 15.00 | 10.99 | 1 | 10.99 | 8.51 | 8.51 | 0.00 | 0.100 | 2
2008167TJWDWWB | Completed |  | 36-989 | 36-989-S7-W | 11.00 | 9.90 | 1 | 9.90 | 1.10 | 1.10 | 0.00 | 0.300 | 2
2008046F70S99Y | Completed |  | 36-2016-5A/2017-5A/2017-6A/2017-7A | 36-2016-5A-R | 10.00 | 6.49 | 1 | 6.49 | 4.50 | 4.50 | 0.00 | 0.100 | 5
2008046F70S99Y | Completed |  | 36-2016-5A/2017-5A/2017-6A/2017-7A | 36-2016-5A-B | 10.00 | 5.50 | 1 | 5.50 | 4.50 | 4.50 | 0.00 | 0.100 | 5
2008046F70S99Y | Completed |  | 36-2016-5A/2017-5A/2017-6A/2017-7A | 36-2017-5A-Y | 12.00 | 6.90 | 1 | 6.90 | 6.50 | 6.50 | 0.00 | 0.100 | 5
2008046F70S99Y | Completed |  | 36-2016-5A/2017-5A/2017-6A/2017-7A | 36-2017-5A-S | 12.00 | 6.90 | 2 | 13.80 | 13.00 | 13.00 | 0.00 | 0.200 | 5
200816889X9NQ3 | Completed |  | 36-AT288 | 36-AT288D-Y | 35.00 | 29.30 | 1 | 29.30 | 5.10 | 5.10 | 0.00 | 0.500 | 5
200816889X9NQ3 | Completed |  | 36-ZR2043 | 36-ZR2043D | 25.00 | 19.50 | 1 | 19.50 | 5.10 | 5.10 | 0.00 | 0.350 | 5
200816889X9NQ3 | Completed |  | 93-659/666 | 93-659 | 1.50 | 1.35 | 3 | 4.05 | 0.45 | 0.45 | 0.00 | 0.300 | 5
200801UPSFD61E | Completed |  | 36-2016-5A/2017-5A/2017-6A/2017-7A | 36-2016-5A-B | 10.00 | 6.36 | 2 | 12.72 | 7.02 | 7.02 | 0.00 | 0.200 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Batu Caves | Selangor | MY | 68100 | Tolong pos dlm kotak.. Tq | 2020-08-11 07:38
200801UQKQX91E | Completed |  | 83-2142/2026/2139/2022 | 83-2139 | 2.20 | 1.90 | 30 | 57.00 | 9.00 | 9.00 | 0.00 | 3.000 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | MY | 26900 |  | 2020-08-06 22:01
200801UR0S2E74 | Completed |  | 36-622/623/624/625/626/633 | 36-625 | 20.00 | 15.90 | 1 | 15.90 | 4.10 | 4.10 | 0.00 | 0.100 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jerantut | [NAME] | MY | 27000 |  | 2020-08-10 07:39
200801UR45F6RP | Completed |  | 36-238 | 238X | 15.00 | 7.90 | 1 | 7.90 | 7.10 | 7.10 | 0.00 | 0.200 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sarawak | MY | 94300 | Pls help wrap the item properly . Tq | 2020-08-07 16:52
200801UR45F6RP | Completed |  | 36-GG-968 | 36-968-6 | 15.00 | 8.50 | 1 | 8.50 | 6.50 | 6.50 | 0.00 | 0.200 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sarawak | MY | 94300 | Pls help wrap the item properly . Tq | 2020-08-07 16:52
200801UR45F6RP | Completed |  | 36-GG-968 | 36-968-7 | 15.00 | 8.50 | 1 | 8.50 | 6.50 | 6.50 | 0.00 | 0.200 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sarawak | MY | 94300 | Pls help wrap the item properly . Tq | 2020-08-07 16:52
200801UR45F6RP | Completed |  | 36-GG-968 | 36-968-8 | 15.00 | 8.50 | 1 | 8.50 | 6.50 | 6.50 | 0.00 | 0.200 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sarawak | MY | 94300 | Pls help wrap the item properly . Tq | 2020-08-07 16:52
200801URQ3FK6N | Completed |  | 85-LF56T180 |  | 35.00 | 31.50 | 1 | 31.50 | 3.50 | 3.50 | 0.00 | 0.900 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sungkai | Perak | MY | 35600 |  | 2020-08-05 19:45
200801US18JN61 | Completed |  | 36-3170/3171 | 36-3170-P | 28.00 | 23.00 | 1 | 23.00 | 9.00 | 9.00 | 0.00 | 0.400 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hulu Langat | Selangor | MY | 43200 |  | 2020-08-09 07:32
200801US8Q34P1 | Completed |  | 89-8901 |  | 22.00 | 19.80 | 1 | 19.80 | 2.20 | 2.20 | 0.00 | 0.300 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cheras | Kuala Lumpur | MY | 58200 |  | 2020-08-06 07:44
200801USBRTT41 | Completed |  | 36-3173 |  | 22.00 | 19.00 | 1 | 19.00 | 3.00 | 3.00 | 0.00 | 0.400 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kuantan | [NAME] | MY | 26070 |  | 2020-08-06 16:18
200801USTCG4B9 | Completed |  | 90-LJ115 |  | 3.50 | 3.15 | 1 | 3.15 | 0.35 | 0.35 | 0.00 | 0.100 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Puchong | Selangor | MY | 47180 |  | 2020-08-09 00:56
200801USTCG4B9 | Completed |  | 92-GLE2001/4001 | 92-GLE2001 | 1.00 | 0.80 | 2 | 1.60 | 0.40 | 0.40 | 0.00 | 0.020 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Puchong | Selangor | MY | 47180 |  | 2020-08-09 00:56
200801USTCG4B9 | Completed |  | 93-DPG/84-KY-011/84-KY-2019 | 93-KY-2019 | 2.50 | 2.40 | 1 | 2.40 | 0.61 | 0.61 | 0.00 | 0.020 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Puchong | Selangor | MY | 47180 |  | 2020-08-09 00:56
200801USTCG4B9 | Completed |  | 89-GD618-3/4 | 89-GD618-3 | 6.00 | 5.40 | 1 | 5.40 | 0.60 | 0.60 | 0.00 | 0.100 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Puchong | Selangor | MY | 47180 |  | 2020-08-09 00:56
200801USTCG4B9 | Completed |  | 09-FS300 |  | 3.00 | 2.50 | 2 | 5.00 | 1.00 | 1.00 | 0.00 | 0.200 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Puchong | Selangor | MY | 47180 |  | 2020-08-09 00:56
200801UT29BRNP | Completed |  | 93-DPG/84-KY-011/84-KY-2019 | 93-KY-2019 | 2.50 | 2.40 | 5 | 12.00 | 3.05 | 3.05 | 0.00 | 0.100 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Petaling Jaya | Selangor | MY | 47301 |  | 2020-08-09 07:50
200801UUTD55B7 | Completed |  | 36-P5 |  | 25.00 | 15.90 | 1 | 15.90 | 9.10 | 9.10 | 0.00 | 0.400 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Puchong | Selangor | MY | 47100 |  | 2020-08-05 10:09
200801UVH6R0C7 | Cancelled |  | 36-989 | 36-989-S16-BK | 14.00 | 12.50 | 2 | 25.00 | 9.00 | 9.00 | 0.00 | 0.600 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kemaman | Terengganu | MY | 24000
200801UVP127Q1 | Cancelled |  | 36-989 | 36-989-S16-R | 14.00 | 12.50 | 1 | 12.50 | 4.50 | 4.50 | 0.00 | 0.300 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kemaman | Terengganu | MY | 24000