Hello Team
I'm having trouble working out the best approach to my problem. I have a raw data CSV output from our online ordering software, but it bunches all the customer order information onto one field. It's possible to use text to column to split out the items, but there are two problems to get the data automatically into the format in the attached "results" image.
1) The orders don't sit under a relevant heading
2) Orders also have a multiple next to them for how many of each item they have ordered - again this can be split out separately using text to columns, splitting on the 2x. Alternatively I thought about an approach where I am able to move the item with the multiplier under the correct column, then use the find and replace function to remove the item name leaving only the number,
You'll not in the results picture, some items are aggregated under one column, like wine and the cake. This isn't really required, it would be OK if these formed under their own single column each like the other items.
Warm regards
James
I'm having trouble working out the best approach to my problem. I have a raw data CSV output from our online ordering software, but it bunches all the customer order information onto one field. It's possible to use text to column to split out the items, but there are two problems to get the data automatically into the format in the attached "results" image.
1) The orders don't sit under a relevant heading
2) Orders also have a multiple next to them for how many of each item they have ordered - again this can be split out separately using text to columns, splitting on the 2x. Alternatively I thought about an approach where I am able to move the item with the multiplier under the correct column, then use the find and replace function to remove the item name leaving only the number,
You'll not in the results picture, some items are aggregated under one column, like wine and the cake. This isn't really required, it would be OK if these formed under their own single column each like the other items.
Warm regards
James
RunSheet 26 Aug 2021 (generated 8.23.21 6_44 PM).xlsx | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |||
1 | Date | Service or Event | Time | Number of People | Booked At | Customer | Company | Table(s) | Section | Status | Phone | Tags | Booking Options | Payment Amount | Payment Type | Transaction Id | Booking reference | Staff Name | Booking Method | Multiple Venues | Notes | Customer Notes | Links | |||
2 | ######### | Dine at Home | 3:00 PM | 1 | ######### | Customer 1 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 2, Shepherd's Pie (2 ppl) $95 x 1 | 37539657 | online | ||||||||||||||
3 | ######### | Dine at Home | 3:00 PM | 1 | ######### | Customer 2 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 1, Nick Spencer Grüner $38 x 1, Creamy Tiramisu Cake (Single) $15 x 1, Strawberry Cheesecake (Single) $15 x 1 | 25768036 | online | ||||||||||||||
4 | ######### | Dine at Home | 3:00 PM | 1 | ######### | Customer 3 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 1, Strawberry Cheesecake (Single) $15 x 2 | 19223131 | online | ||||||||||||||
5 | ######### | Dine at Home | 3:00 PM | 1 | ######### | Customer 4 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 1, Blackberry Chocolate Cake (Single) $15 x 1, Creamy Tiramisu Cake (Single) $15 x 1 | 25902088 | online | ||||||||||||||
6 | ######### | Dine at Home | 3:30 PM | 1 | ######### | Customer 5 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 1, Shepherd's Pie (2 ppl) $95 x 1, Creamy Tiramisu Cake (Single) $15 x 2, Strawberry Cheesecake (Single) $15 x 2 | 29015825 | online | ||||||||||||||
7 | ######### | Dine at Home | 4:30 PM | 1 | ######### | Customer 6 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 1, Creamy Tiramisu Cake (Single) $15 x 1 | 34781626 | online | ||||||||||||||
8 | ######### | Dine at Home | 4:30 PM | 1 | ######### | Customer 7 | 1 | Dine at Home | Confirmed | Jerusalem artichoke agnolotti (Vego) (2 ppl) $95 x 1 | 20541130 | online | ||||||||||||||
9 | ######### | Dine at Home | 4:30 PM | 1 | ######### | Customer 8 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 1, Creamy Tiramisu Cake (Single) $15 x 1 | 36682398 | online | ||||||||||||||
10 | ######### | Dine at Home | 4:45 PM | 1 | ######### | Customer 9 | 1 | Dine at Home | Confirmed | Shepherd's Pie (2 ppl) $95 x 1 | 36535767 | online | ||||||||||||||
11 | ######### | Dine at Home | 4:45 PM | 1 | ######### | Customer 10 | 1 | Dine at Home | Confirmed | Shepherd's Pie (2 ppl) $95 x 1, Creamy Tiramisu Cake (Single) $15 x 3 | 45983355 | online | Thank you | |||||||||||||
12 | ######### | Dine at Home | 4:45 PM | 1 | ######### | Customer 11 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 1, Blackberry Chocolate Cake (Single) $15 x 1 | 62363029 | online | Chicken only, no other meat. Ordering for my wife's birthday. Subject to pick up available during lockdown. | |||||||||||||
13 | ######### | Dine at Home | 4:45 PM | 1 | ######### | Customer 12 | 1 | Dine at Home | Confirmed | Jerusalem artichoke agnolotti (Vego) (2 ppl) $95 x 1, Blackberry Chocolate Cake (Single) $15 x 1, Strawberry Cheesecake (Single) $15 x 1 | 22093976 | online | ||||||||||||||
14 | ######### | Dine at Home | 4:45 PM | 1 | ######### | Customer 13 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 1, 1/2 Doz Freshly Shucked Appellation Oysters $25 x 2, 2018 Mount Majura Shiraz $38 x 1, Creamy Tiramisu Cake (Single) $15 x 2 | 37788094 | online | ||||||||||||||
15 | ######### | Dine at Home | 5:00 PM | 1 | ######### | Customer 14 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 1, Blackberry Chocolate Cake (Single) $15 x 1, Creamy Tiramisu Cake (Single) $15 x 1 | 72236640 | online | ||||||||||||||
16 | ######### | Dine at Home | 5:00 PM | 1 | ######### | Customer 15 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 1 | 1588227 | online | Married here 26th August 2018 | |||||||||||||
17 | ######### | Dine at Home | 5:00 PM | 1 | ######### | Customer 16 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 1 | 51224778 | online | ||||||||||||||
18 | ######### | Dine at Home | 5:00 PM | 1 | ######### | Customer 17 | 1 | Dine at Home | Confirmed | Jerusalem artichoke agnolotti (Vego) (2 ppl) $95 x 1, 2018 Mount Majura Shiraz $38 x 1, Creamy Tiramisu Cake (Single) $15 x 1 | 57443158 | online | ||||||||||||||
19 | ######### | Dine at Home | 5:00 PM | 1 | ######### | Customer 18 | 1 | Dine at Home | Confirmed | Roast Spatchcock (2 ppl) $95 x 1, Creamy Tiramisu Cake (Single) $15 x 1 | 19441989 | online | Family friend of Jamie's | |||||||||||||
RunSheet 26 Aug 2021 (generated |