Spreadsheet: 461523d1463632173-move-data-from-rows-into-columns-excel-forum-query
Sheet: excel forum

OrderID | CustomerID | CustomerFirst | CustomerLast | CustomerEmail | CustomerType | CompanyName | OrderDate | OrderStatus | SubTotal | TaxesBilled | ShippingBilled | HandlingBilled | DiscountAmount | DiscountList | GrandTotal | CostTotal | ShippingMethodUsed | ShipDate | ApprovedCreditCardPaymentTotal | PaymentMethod | PaymentType | PaymentAmount | PaymentDate | PaymentRejectReason | PaymentAuthorizationCode | CustomerIpAddress | CustomerReferredFromUrl | CustomerLandedOnUrl | TrackingCodeList | TrackingUrlList | SpecialInstructions | Comments | AffiliateOrderCameFrom | TrafficSource | TrafficSearchPhrase | PayPerClickOrder | PayPerClickKeywordUsed | RepeatOrderFromCustomer | InitialOrderFromCustomer | ShipAddressLine1 | ShipAddressLine2 | ShipAddressAlternatePhone | ShipAddressCity | ShipAddressComments | ShipAddressCompany | ShipAddressFax | ShipAddressName | ShipAddressPhone | ShipAddressCountry | ShipAddressCountryCode | ShipAddressStateCode | ShipAddressState | ShipAddressZip | BillAddressLine1 | BillAddressLine2 | BillAddressAlternatePhone | BillAddressCity | BillAddressComments | BillAddressCompany | BillAddressFax | BillAddressName | BillAddressPhone | BillAddressCountry | BillAddressCountryCode | BillAddressStateCode | BillAddressState | BillAddressZip | TotalWeight | ResidentialAddress | ShipmentNotification | ServiceName | OrderItems | OrderItems2 | OrderItems3 | OrderItems4 | OrderItems5 | OrderItems6 | OrderItems7 | OrderItems8 | OrderItems9 | OrderItems10 | OrderItems11 | OrderItems12 | OrderItems13 | OrderItems14 | MfgInvoiceNumber | MfgInvoiceAmount | MfgInvoicePaid | CCType | CCNumber | CCExpMonth | CCExpYear | CCCVV | CCName | CCAVSResponse | CustomPaymentMethodFields | CustomerSalesPerson | IsGift | GiftMessage | PublicComments | Instructions | TaxCode | CustomerNoTaxFlag | GoogleCheckoutOrderNumber | EnteredBy | EnteredDate | LastEditedBy | LastEditDate | ShipAddressFirstName | ShipAddressLastName | BillAddressFirstName | BillAddressLastName | CustomerNumber | AdditionalFeesBilled | CCExpMonthYear | PaymentMethodOrCCType | OrderTime | ItemCount | CouponCode | CampaignCode | OrderType | AdCode | ShippingClassificationCode | ItemDiscountAmount | ItemShippingAmount | ItemTaxAmount | ItemSubtotal | ItemTotal | ItemQuantityShipped | ItemOtherDiscount | ItemWarehouseID | ItemWarehouseName | ItemWarehouseAddressLine1 | ItemWarehouseAddressLine2 | ItemWarehouseCity | ItemWarehouseStateID | ItemWarehouseNonUSState | ItemWarehouseCountryID | ItemWarehouseZip | ItemEproductSerialNumber | SendReviewRequest | ReviewProduct | SurveySent
102952 | 3971 | [NAME] | M | sis@xxxx. |  |  | 2/23/2015 7:06:00 AM | [NAME] (Send Notification) | 109.36 | 16.4 | 0 | 0 | 0 |  | 125.76 | 7.25 | AB - Free Shipping | 2/25/2015 |  | Credit Card | CreditCard | 118.26 | 2/23/2015 9:12:56 PM |  | VTYRCE148BBB | 61.244.112.1 |  | http://abc.thefirm.com/Store/Category.aspx?catID=27 |  |  |  |  |  | [none] |  | 0 |  |  |  | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | SS | +6421 401 410 | Zone A | AB |  | AB | 1023 | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | [NAME] | +6421 401 410 | Zone A | AB |  | AB | 1023 | 2.72 | Y | Y | 13 | AB-R46-P~Renewal Coconut  Oil~2~15.20~The Firm (Fiji)~~Infusion: [NAME] | AB-R46-W~Renewal Coconut  Oil~1~15.20~The Firm (Fiji)~~Infusion: Watermelon~ | AB-R-F~Renewal Coconut  Oil (Travel Size)~2~4.76~The Firm (Fiji)~~Infusion: [NAME] | AB-R-P~Renewal Coconut  Oil (Travel Size)~1~4.76~The Firm (Fiji)~~Infusion: [NAME] | AB-R-T~Renewal Coconut  Oil (Travel Size)~2~4.76~The Firm (Fiji)~~Infusion: Tiare~ | AB-R50-F~Renewal Coconut Shampoo ~1~10.00~The Firm (Fiji)~~Infusion: [NAME] | AB-R51-F~Renewal Coconut Conditioner~1~10.00~The Firm (Fiji)~~Infusion: [NAME] | AB-R48-T~Renewal Coconut Shower Gel~1~4.33~The Firm (Fiji)~~Infusion: Tiare~ | AB-R47-P~Renewal Coconut Soap~1~3.48~The Firm (Fiji)~~Infusion: [NAME] | AB-R47-W~Renewal Coconut Soap~1~3.48~The Firm (Fiji)~~Infusion: Watermelon~ | AB-R44-P~Renewal Coconut  Butter~1~8.67~The Firm (Fiji)~~Infusion: [NAME] |  |  |  |  | 0 |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 2/23/2015 7:06:03 AM | marissa | 2/25/2015 8:52:22 PM | [NAME] | Sisepi-fraser | [NAME] | Sisepi-fraser |  | 0 | Not Viewable | Not Viewable | 07:06:00 | 11 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True
107083 | 18395 | Brigit | L | sis@xxxx. | Retail |  | 8/22/2015 10:09:00 PM | [NAME] (Reconciled) | 311.75 | 46.76 | 0 | 0 | 0 |  | 358.51 | 0 | AB - Charged | 8/23/2015 |  | Credit Card | CreditCard | 358.51 | 8/22/2015 10:08:36 PM |  | AU0RD77198AB | [NAME] | http://www.thefirm.com/buy-online/ | https://abc.thefirm.com/Default.aspx |  |  |  |  |  | [none] |  | 0 |  |  |  | 186A Ponsonby Rd | [NAME] |  | Apple City | Please deliver upstairs behind store | Working Style |  | BL | 210703625 | Zone A | AB |  | AB | 1011 | 12A Heathglen Pl | Bayview |  | Apple City |  |  |  | [NAME] | 210703625 | Zone A | AB |  | AB | 629 | 4.52 | Y | Y | 13 | AB-FS-DC~Hydrating Multi Active Day Créme~1~60.00~The Firm~~~ | AB-PF-BB-C~ Butter~1~40.00~The Firm~~Infusion: Coconut~ | AB-PF-CN-C~Coconut Créme Conditioner~1~22.17~The Firm~~Infusion: Coconut~ | AB-PF-SP-C~Coconut Milk Shampoo~1~22.17~The Firm~~Infusion: Coconut~ | AB-PF-BS-C~Coconut Créme  Scrub~1~30.87~The Firm~~Infusion: Coconut~ | AB-PF-SS110-M~Spa Soap~1~8.70~The Firm~~Infusion: Mango~ | AB-PF-SS110-H~Spa Soap~1~8.70~The Firm~~Infusion: Coconut Milk & Honey~ | AB-PF-SS110-C~Spa Soap~1~8.70~The Firm~~Infusion: Coconut~ | AB-DL-BG16~Dilo Rescue  Gel 16oz~1~50.00~The Firm~~~ | AB-PF-RM3-S~Room Mist~1~13.48~The Firm~~Infusion: Starfruit~ | AB-R-SS-W~Renewal Coconut Soap~1~6.96~The Firm~~Infusion: Watermelon~ | AB-PF-BB-M~ Butter~1~40.00~The Firm~~Infusion: Mango~ |  |  |  |  |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 8/22/2015 10:08:36 PM | zoe+products | 11/16/2015 7:04:03 PM | Brigit | [NAME] | Brigit | [NAME] |  | 0 | Not Viewable | Not Viewable | 22:09:00 | 12 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True | True
111468 | 4571 | Julie | R | sis@xxxx. | Retail |  | 11/26/2015 7:56:00 PM | [NAME] (Reconciled) | 405.61 | 45.63 | 0 | 0 | 101.4 | 2015 - Black Friday - AB | 349.84 | 0 | AB - Free Shipping | 2015-01-12 00:00:00 |  | Credit Card | CreditCard | 349.84 | 11/26/2015 7:55:42 PM |  | AP0RCA633060 | 115.188.211.212 |  | https://abc.thefirm.com/Default.aspx?utm_medium=email&amp;utm_campaign=AB+-+Fiji+Day&amp;utm_content=AB+-+Fiji+Day+Version+A+CID_55febacf27f62d918113b78e478c92ce&amp;utm_source=Email&amp;utm_term=The Firm - AB ONLINE STORE |  |  |  |  |  | [none] |  | 0 |  |  |  | 257 Otaki Gorge Road | Hautere |  | Otaki |  |  |  | JL | (646)364-2131 | Zone A | AB |  | AB | 5582 | 257 Otaki Gorge Road | Hautere |  | Otaki |  |  |  | [NAME] | (646)364-2131 | Zone A | AB |  | AB | 5582 | 7.84 | Y | Y | 13 | AB-R-SS-C~Renewal Coconut Soap~2~6.96~The Firm~~Infusion: Coconut~ | AB-R-SS-F~Renewal Coconut Soap~2~6.96~The Firm~~Infusion: [NAME] | AB-R-SS-N~Renewal Coconut Soap~2~6.96~The Firm~~Infusion: [NAME] | AB-R-SS-W~Renewal Coconut Soap~2~6.96~The Firm~~Infusion: Watermelon~ | AB-PF-SR-N~Coconut Sugar Rub~1~57.83~The Firm~~Infusion: [NAME] | AB-PF-SR-C~Coconut Sugar Rub~1~57.83~The Firm~~Infusion: Coconut~ | AB-PF-SR-H~Coconut Sugar Rub~1~57.83~The Firm~~Infusion: Coconut Milk & Honey~ | AB-PF-SR-S~Coconut Sugar Rub~1~57.83~The Firm~~Infusion: Starfruit~ | AB-PF-SR-G~Coconut Sugar Rub~1~57.83~The Firm~~Infusion: White Gingerlily~ | AB-R-BO-N~Renewal Coconut  Oil~1~30.39~The Firm~~Infusion: [NAME] | AB-R-BO-W~Renewal Coconut  Oil~1~30.39~The Firm~~Infusion: Watermelon~ |  |  |  |  |  |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  | I note there are reward points "pending" from September orders ... would be great if those could be used against this order.  Many thanks :) |  |  | False |  | [EMAIL] | 11/26/2015 7:55:42 PM | sonia | 12/16/2015 6:51:55 PM | Julie | Riepen | Julie | Riepen |  | 0 | Not Viewable | Not Viewable | 19:56:00 | 11 | BF15 |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True | True
Above, rows 2, 3 and 4 are my original file. They show order numbers, clients details etc. Cells BU to CH show the products purchased. They are lined up in consequent cells; however, I need to turn this fille into a pivot table.
To do that, I need to repeat the entire row 2 for all values, exactly as they are, as many times as necessary, but with the data from columns BV to CH stacked up under BU.
Below, from rows 11 to 21, first I copied row 2 above into row 11, then I copied cells from BV to CH, then used Paste value, transpose, under column BU. Then copied A11 to BT11 and pasted underneath from row 12 to 21.
Then copied from CI11 to EN11 and pasted underneath from row 12 to 21 again. I need a better way to do that, because my file has thousands of entries.
102952 | 3971 | [NAME] | M | sis@xxxx. |  |  | 2/23/2015 7:06:00 AM | [NAME] (Send Notification) | 109.36 | 16.4 | 0 | 0 | 0 |  | 125.76 | 7.25 | AB - Free Shipping | 2/25/2015 |  | Credit Card | CreditCard | 118.26 | 2/23/2015 9:12:56 PM |  | VTYRCE148BBB | 61.244.112.1 |  | http://abc.thefirm.com/Store/Category.aspx?catID=27 |  |  |  |  |  | [none] |  | 0 |  |  |  | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | SS | +6421 401 410 | Zone A | AB |  | AB | 1023 | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | [NAME] | +6421 401 410 | Zone A | AB |  | AB | 1023 | 2.72 | Y | Y | 13 | AB-R46-P~Renewal Coconut  Oil~2~15.20~The Firm (Fiji)~~Infusion: [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 2/23/2015 7:06:03 AM | marissa | 2/25/2015 8:52:22 PM | [NAME] | Sisepi-fraser | [NAME] | Sisepi-fraser |  | 0 | Not Viewable | Not Viewable | 07:06:00 | 11 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True
102952 | 3971 | [NAME] | M | sis@xxxx. |  |  | 2/23/2015 7:06:00 AM | [NAME] (Send Notification) | 109.36 | 16.4 | 0 | 0 | 0 |  | 125.76 | 7.25 | AB - Free Shipping | 2/25/2015 |  | Credit Card | CreditCard | 118.26 | 2/23/2015 9:12:56 PM |  | VTYRCE148BBB | 61.244.112.1 |  | http://abc.thefirm.com/Store/Category.aspx?catID=27 |  |  |  |  |  | [none] |  | 0 |  |  |  | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | SS | +6421 401 410 | Zone A | AB |  | AB | 1023 | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | [NAME] | +6421 401 410 | Zone A | AB |  | AB | 1023 | 2.72 | Y | Y | 13 | AB-R46-W~Renewal Coconut  Oil~1~15.20~The Firm (Fiji)~~Infusion: Watermelon~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 2/23/2015 7:06:03 AM | marissa | 2/25/2015 8:52:22 PM | [NAME] | Sisepi-fraser | [NAME] | Sisepi-fraser |  | 0 | Not Viewable | Not Viewable | 07:06:00 | 11 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True
102952 | 3971 | [NAME] | M | sis@xxxx. |  |  | 2/23/2015 7:06:00 AM | [NAME] (Send Notification) | 109.36 | 16.4 | 0 | 0 | 0 |  | 125.76 | 7.25 | AB - Free Shipping | 2/25/2015 |  | Credit Card | CreditCard | 118.26 | 2/23/2015 9:12:56 PM |  | VTYRCE148BBB | 61.244.112.1 |  | http://abc.thefirm.com/Store/Category.aspx?catID=27 |  |  |  |  |  | [none] |  | 0 |  |  |  | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | SS | +6421 401 410 | Zone A | AB |  | AB | 1023 | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | [NAME] | +6421 401 410 | Zone A | AB |  | AB | 1023 | 2.72 | Y | Y | 13 | AB-R-F~Renewal Coconut  Oil (Travel Size)~2~4.76~The Firm (Fiji)~~Infusion: [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 2/23/2015 7:06:03 AM | marissa | 2/25/2015 8:52:22 PM | [NAME] | Sisepi-fraser | [NAME] | Sisepi-fraser |  | 0 | Not Viewable | Not Viewable | 07:06:00 | 11 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True
102952 | 3971 | [NAME] | M | sis@xxxx. |  |  | 2/23/2015 7:06:00 AM | [NAME] (Send Notification) | 109.36 | 16.4 | 0 | 0 | 0 |  | 125.76 | 7.25 | AB - Free Shipping | 2/25/2015 |  | Credit Card | CreditCard | 118.26 | 2/23/2015 9:12:56 PM |  | VTYRCE148BBB | 61.244.112.1 |  | http://abc.thefirm.com/Store/Category.aspx?catID=27 |  |  |  |  |  | [none] |  | 0 |  |  |  | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | SS | +6421 401 410 | Zone A | AB |  | AB | 1023 | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | [NAME] | +6421 401 410 | Zone A | AB |  | AB | 1023 | 2.72 | Y | Y | 13 | AB-R-P~Renewal Coconut  Oil (Travel Size)~1~4.76~The Firm (Fiji)~~Infusion: [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 2/23/2015 7:06:03 AM | marissa | 2/25/2015 8:52:22 PM | [NAME] | Sisepi-fraser | [NAME] | Sisepi-fraser |  | 0 | Not Viewable | Not Viewable | 07:06:00 | 11 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True
102952 | 3971 | [NAME] | M | sis@xxxx. |  |  | 2/23/2015 7:06:00 AM | [NAME] (Send Notification) | 109.36 | 16.4 | 0 | 0 | 0 |  | 125.76 | 7.25 | AB - Free Shipping | 2/25/2015 |  | Credit Card | CreditCard | 118.26 | 2/23/2015 9:12:56 PM |  | VTYRCE148BBB | 61.244.112.1 |  | http://abc.thefirm.com/Store/Category.aspx?catID=27 |  |  |  |  |  | [none] |  | 0 |  |  |  | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | SS | +6421 401 410 | Zone A | AB |  | AB | 1023 | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | [NAME] | +6421 401 410 | Zone A | AB |  | AB | 1023 | 2.72 | Y | Y | 13 | AB-R-T~Renewal Coconut  Oil (Travel Size)~2~4.76~The Firm (Fiji)~~Infusion: Tiare~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 2/23/2015 7:06:03 AM | marissa | 2/25/2015 8:52:22 PM | [NAME] | Sisepi-fraser | [NAME] | Sisepi-fraser |  | 0 | Not Viewable | Not Viewable | 07:06:00 | 11 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True
102952 | 3971 | [NAME] | M | sis@xxxx. |  |  | 2/23/2015 7:06:00 AM | [NAME] (Send Notification) | 109.36 | 16.4 | 0 | 0 | 0 |  | 125.76 | 7.25 | AB - Free Shipping | 2/25/2015 |  | Credit Card | CreditCard | 118.26 | 2/23/2015 9:12:56 PM |  | VTYRCE148BBB | 61.244.112.1 |  | http://abc.thefirm.com/Store/Category.aspx?catID=27 |  |  |  |  |  | [none] |  | 0 |  |  |  | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | SS | +6421 401 410 | Zone A | AB |  | AB | 1023 | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | [NAME] | +6421 401 410 | Zone A | AB |  | AB | 1023 | 2.72 | Y | Y | 13 | AB-R50-F~Renewal Coconut Shampoo ~1~10.00~The Firm (Fiji)~~Infusion: [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 2/23/2015 7:06:03 AM | marissa | 2/25/2015 8:52:22 PM | [NAME] | Sisepi-fraser | [NAME] | Sisepi-fraser |  | 0 | Not Viewable | Not Viewable | 07:06:00 | 11 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True
102952 | 3971 | [NAME] | M | sis@xxxx. |  |  | 2/23/2015 7:06:00 AM | [NAME] (Send Notification) | 109.36 | 16.4 | 0 | 0 | 0 |  | 125.76 | 7.25 | AB - Free Shipping | 2/25/2015 |  | Credit Card | CreditCard | 118.26 | 2/23/2015 9:12:56 PM |  | VTYRCE148BBB | 61.244.112.1 |  | http://abc.thefirm.com/Store/Category.aspx?catID=27 |  |  |  |  |  | [none] |  | 0 |  |  |  | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | SS | +6421 401 410 | Zone A | AB |  | AB | 1023 | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | [NAME] | +6421 401 410 | Zone A | AB |  | AB | 1023 | 2.72 | Y | Y | 13 | AB-R51-F~Renewal Coconut Conditioner~1~10.00~The Firm (Fiji)~~Infusion: [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 2/23/2015 7:06:03 AM | marissa | 2/25/2015 8:52:22 PM | [NAME] | Sisepi-fraser | [NAME] | Sisepi-fraser |  | 0 | Not Viewable | Not Viewable | 07:06:00 | 11 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True
102952 | 3971 | [NAME] | M | sis@xxxx. |  |  | 2/23/2015 7:06:00 AM | [NAME] (Send Notification) | 109.36 | 16.4 | 0 | 0 | 0 |  | 125.76 | 7.25 | AB - Free Shipping | 2/25/2015 |  | Credit Card | CreditCard | 118.26 | 2/23/2015 9:12:56 PM |  | VTYRCE148BBB | 61.244.112.1 |  | http://abc.thefirm.com/Store/Category.aspx?catID=27 |  |  |  |  |  | [none] |  | 0 |  |  |  | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | SS | +6421 401 410 | Zone A | AB |  | AB | 1023 | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | [NAME] | +6421 401 410 | Zone A | AB |  | AB | 1023 | 2.72 | Y | Y | 13 | AB-R48-T~Renewal Coconut Shower Gel~1~4.33~The Firm (Fiji)~~Infusion: Tiare~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 2/23/2015 7:06:03 AM | marissa | 2/25/2015 8:52:22 PM | [NAME] | Sisepi-fraser | [NAME] | Sisepi-fraser |  | 0 | Not Viewable | Not Viewable | 07:06:00 | 11 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True
102952 | 3971 | [NAME] | M | sis@xxxx. |  |  | 2/23/2015 7:06:00 AM | [NAME] (Send Notification) | 109.36 | 16.4 | 0 | 0 | 0 |  | 125.76 | 7.25 | AB - Free Shipping | 2/25/2015 |  | Credit Card | CreditCard | 118.26 | 2/23/2015 9:12:56 PM |  | VTYRCE148BBB | 61.244.112.1 |  | http://abc.thefirm.com/Store/Category.aspx?catID=27 |  |  |  |  |  | [none] |  | 0 |  |  |  | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | SS | +6421 401 410 | Zone A | AB |  | AB | 1023 | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | [NAME] | +6421 401 410 | Zone A | AB |  | AB | 1023 | 2.72 | Y | Y | 13 | AB-R47-P~Renewal Coconut Soap~1~3.48~The Firm (Fiji)~~Infusion: [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 2/23/2015 7:06:03 AM | marissa | 2/25/2015 8:52:22 PM | [NAME] | Sisepi-fraser | [NAME] | Sisepi-fraser |  | 0 | Not Viewable | Not Viewable | 07:06:00 | 11 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True
102952 | 3971 | [NAME] | M | sis@xxxx. |  |  | 2/23/2015 7:06:00 AM | [NAME] (Send Notification) | 109.36 | 16.4 | 0 | 0 | 0 |  | 125.76 | 7.25 | AB - Free Shipping | 2/25/2015 |  | Credit Card | CreditCard | 118.26 | 2/23/2015 9:12:56 PM |  | VTYRCE148BBB | 61.244.112.1 |  | http://abc.thefirm.com/Store/Category.aspx?catID=27 |  |  |  |  |  | [none] |  | 0 |  |  |  | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | SS | +6421 401 410 | Zone A | AB |  | AB | 1023 | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | [NAME] | +6421 401 410 | Zone A | AB |  | AB | 1023 | 2.72 | Y | Y | 13 | AB-R47-W~Renewal Coconut Soap~1~3.48~The Firm (Fiji)~~Infusion: Watermelon~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 2/23/2015 7:06:03 AM | marissa | 2/25/2015 8:52:22 PM | [NAME] | Sisepi-fraser | [NAME] | Sisepi-fraser |  | 0 | Not Viewable | Not Viewable | 07:06:00 | 11 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True
102952 | 3971 | [NAME] | M | sis@xxxx. |  |  | 2/23/2015 7:06:00 AM | [NAME] (Send Notification) | 109.36 | 16.4 | 0 | 0 | 0 |  | 125.76 | 7.25 | AB - Free Shipping | 2/25/2015 |  | Credit Card | CreditCard | 118.26 | 2/23/2015 9:12:56 PM |  | VTYRCE148BBB | 61.244.112.1 |  | http://abc.thefirm.com/Store/Category.aspx?catID=27 |  |  |  |  |  | [none] |  | 0 |  |  |  | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | SS | +6421 401 410 | Zone A | AB |  | AB | 1023 | 21 St Andrews Road | [NAME] |  | Apple City |  |  |  | [NAME] | +6421 401 410 | Zone A | AB |  | AB | 1023 | 2.72 | Y | Y | 13 | AB-R44-P~Renewal Coconut  Butter~1~8.67~The Firm (Fiji)~~Infusion: [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable | Not Viewable |  |  |  | False |  |  |  |  | False |  | [EMAIL] | 2/23/2015 7:06:03 AM | marissa | 2/25/2015 8:52:22 PM | [NAME] | Sisepi-fraser | [NAME] | Sisepi-fraser |  | 0 | Not Viewable | Not Viewable | 07:06:00 | 11 |  |  | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True