Spreadsheet: 871322d1717696976-merge-data-from-two-sheets-with-multiple-orders-per-customer-ordermergetestfile
Sheet: Orders_6-5-24

orderid | customerid | billingcompanyname | billingfirstname | billinglastname | productcode | productname | quantity | productprice | totalprice
33823 | 27016 | ABCs [NAME] | Maurica | [NAME]
33824 | 22045 |  | [NAME] | Salyers
33825 | 27017 | Jacobs Engineering | Harmony | [NAME]
33826 | 27018 |  | [NAME] | Grant
33827 | 26568 | East To West Henna | Heather | DeRigo
33828 | 24626 | 32826 | ASHWANI / Gokul | KAUL
33833 | 27020 |  | erika | kawalek
33834 | 27021 |  | Olivia | [NAME]
33835 | 25838 |  | Brijesh | Valecha
33836 | 27022 |  | Raegan | Iacometti
33837 | 27023 |  | [NAME] | Blunk
33838 | 26046 |  | Lauren | Lackey
33839 | 27024 |  | Tarsheka | Thompson
33840 | 27025 |  | [NAME] | Walter
33841 | 26031 |  | [NAME] | Snyder
33842 | 27027 |  | [NAME] | velasquez
33843 | 26042 |  | [NAME] | Gehres
33844 | 27028 | Rfe | [NAME] | Painter
33845 | 23663 |  | [NAME] | Block
33846 | 27010 | Henna by Angelica | Angelica | [NAME]
33847 | 27029 |  | [NAME] | [NAME]
33848 | 27030 |  | [NAME] | [NAME]
33849 | 27031 | The Facepaint Faerie | [NAME] | laakko
33850 | 27032 |  | Jeremy | Ondo
33851 | 27033 |  | [NAME] | Stone
33852 | 25874 |  | [NAME] | Nikoloska
33853 | 27034 |  | Julia | Scanlon
33854 | 27035 |  | Thuy | Nguyen
33855 | 27036 |  | Reeka | Marajh
33856 | 27037 |  | Emily | Thompson
33857 | 27038 |  | Maricela | [NAME]
33858 | 27039 | Moving Hands | [NAME] | Danza
33859 | 27040 |  | ISHREEN | BGEUM
33860 | 9139 |  | Kimberly | [NAME]
33861 | 26371 | Creative Faces LLC | Yougnesse | [NAME]
33862 | 27041 | Iskcon | Hector | Guzman
33864 | 27044 |  | jawaria | meah
33865 | 27045 |  | [NAME] | Green
33866 | 27046 |  | [NAME] | Penrod
33867 | 27047 | York Community High School | [NAME] | [NAME]
33868 | 25909 | HerbalNature | [NAME] | Bell
33869 | 25874 |  | [NAME] | Nikoloska
33870 | 27048 |  | Amber | Tavares
33871 | 23593 |  | Kelsey | Jones
33872 | 26568 | East To West Henna | Heather | DeRigo
33873 | 24884 | Henna by jaerene | [NAME] | [NAME]
33876 | 21799 |  | Joseling | Escobar
33877 | 27050 |  | [NAME] | Green
33878 | 27051 |  | [NAME] | Obleschuk
33879 | 27052 |  | [NAME] | [NAME]
33880 | 17371 |  | HOLLY | FERREIRA
33883 | 25540 | Blazin Wolf Productions | M Blaise | Potts
33884 | 27053 |  | [NAME] | LeClair
33885 | 27054 |  | [NAME] | haleem
33886 | 27055 |  | Elena | [NAME]
33887 | 27056 |  | [NAME] | Pettoello
33888 | 27057 |  | Hyiat | El-jundi
33889 | 27051 |  | [NAME] | Obleschuk
33890 | 27058 |  | [NAME] | [NAME]
33891 | 9139 |  | Kimberly | [NAME]
33892 | 13769 |  | Dawn | [NAME]
33893 | 23586 |  | TAMIE | KOZICZKOWSKI
33894 | 3317 |  | Jessica | Ringler
33895 | 27059 |  | Maya | Afik
33896 | 27060 |  | [NAME] | Weaver
33897 | 25421 |  | Maria | Mercuri
33898 | 6507 | [NAME] | [NAME] | [NAME]
33899 | 26620 |  | [NAME] | Wilson
33900 | 27061 |  | maya | bryant
33901 | 27062 |  | nichola | gugliotta
33902 | 27062 |  | nichola | gugliotta
33903 | 27063 |  | Ragini | Bhattacharya
33904 | 27064 |  | Praveen | Chandrasekhar
33905 | 27065 |  | [NAME] | [NAME]
33906 | 20495 |  | [NAME] | Hollman
33907 | 27066 |  | [NAME] | [NAME]
33908 | 27067 |  | D. Mercedes | [NAME]
33909 | 27051 |  | [NAME] | Obleschuk
33910 | 27068 |  | Sue | Ouhmidou
33911 | 21856 |  | [NAME] | [NAME]
33912 | 26343 |  | Kimberly | [NAME]
33913 | 22409 |  | Nissan | [NAME]
33914 | 17708 | Preble County District Library | Mickie | Gayhart
33915 | 20929 |  | Kiyoka | Wada
33916 | 27069 |  | [NAME] | Costa
33917 | 27070 |  | [NAME] | Payne
33918 | 27071 |  | Candice | Hicks
33919 | 27072 |  | jacqueline | jarvis
33920 | 27073 |  | Maria | Shanks
33921 | 27074 |  | [NAME] | Nienaber
33923 | 25874 |  | [NAME] | Nikoloska
33924 | 25369 |  | Christine | Bryant
33925 | 27075 | Mystique Vibes | Dom | Shelby
33926 | 27070 |  | [NAME] | Payne
33927 | 27076 |  | Naila | Saeed
33928 | 27077 |  | riley | horton
33929 | 27079 |  | Uroosa | Ahmed
33930 | 27080 |  | Asma | [NAME]
33931 | 27081 | Unit 103 | [NAME] | Gorf
33932 | 26976 |  | Deepak | Chari
33933 | 27083 |  | [NAME] | [NAME]
33934 | 27084 |  | Emily | Eaton
33935 | 27084 |  | Emily | Eaton
33936 | 27085 |  | Tiffany | Rodriguez
33937 | 27086 |  | [NAME] | Harber
33938 | 26949 |  | Seema | [NAME]
33939 | 27087 |  | Echo | Null
33940 | 1 | East West Henna | Heather | DeRigo
33941 | 27088 |  | [NAME] | [NAME]
33942 | 27089 |  | Mariah | Castillo
33943 | 27090 |  | Chante | Fields
33944 | 27091 |  | Alexis | Madden-Tyler
33945 | 27092 |  | Muriel | Wickman
33946 | 27093 |  | Ayesha | Yousuf
33947 | 27080 |  | Asma | [NAME]
33948 | 27094 |  | [NAME] | [NAME]
33949 | 26668 |  | Kayla | [NAME]
33950 | 27095 |  | [NAME] | [NAME]
33951 | 27096 |  | zahidul | siddique
33952 | 27097 |  | karen | miller
33953 | 27098 |  | [NAME] | [NAME]
33954 | 25940 |  | Heather [NAME] | Head Body And Soul Body Art
33955 | 27099 |  | [NAME] | Wickman
33956 | 17443 |  | [NAME] | Weiss
33957 | 27100 |  | [NAME] | Herrera
33958 | 27101 |  | Alexis | Trahe
33959 | 27102 |  | Arielle | Stanford
33960 | 26828 |  | Taylar | Hagerty
33961 | 27103 |  | Amber | Tavares
33962 | 27104 | Zoe Senior Advocate Services | Tamekka | [NAME]
33963 | 26565 |  | Sue | Thavamoney
33964 | 13120 |  | LAURA | HESS
33965 | 23763 |  | Estefania | Casas
33966 | 27105 |  | [NAME] | [NAME]
33972 | 27110 |  | [NAME] | castillo
33973 | 27111 |  | [NAME] | Drye
33974 | 27112 |  | Jacobo | Quan
33975 | 25940 | Head Body and [NAME] | Heather | [NAME]
33976 | 25485 |  | Preet | [NAME]
33977 | 27113 |  | Robyn | [NAME]
33978 | 27114 |  | [NAME] | Melamed
33979 | 26874 |  | [NAME] | Nikoloska
33980 | 22065 |  | [NAME] | Forte
33981 | 18514 |  | [NAME] | Trosclair
33982 | 27115 |  | Nicole | [NAME]
33983 | 27116 |  | Annalisa | Salazar
33984 | 27117 |  | [NAME] | Gehres
33985 | 27118 |  | Nadia | Alamah
33986 | 18514 |  | [NAME] | Trosclair
33987 | 27119 |  | [NAME] | Pollack
33988 | 27120 |  | [NAME] | Pope
33989 | 27122 | Logos Public Charter School | Emily | Honer
33990 | 27123 |  | [NAME] | Villegas
33991 | 25975 | enjoy your face inc | carmelle | bloxsom
33992 | 27124 |  | [NAME] | Villegas
33993 | 27125 |  | Shaneece | Crum
33994 | 27126 |  | Erin | Goedtel
33995 | 27127 |  | [NAME] | [NAME]
33997 | 27129 |  | Julian | Estrada
33998 | 27130 |  | Amrit | Sarai
33999 | 25540 | Blazin Wolf Productions | M Blaise | Potts
34001 | 27132 |  | [NAME] | Nikoloska
34002 | 27133 |  | Henna | Z
34003 | 27134 |  | [NAME] | Boltik
34004 | 27135 |  | [NAME] | Dinan
34005 | 27136 |  | Kelly | [NAME]
34007 | 17371 |  | HOLLY | FERREIRA
34008 | 27138 |  | Pheannah | West
34009 | 27139 |  | Brittany | [NAME]
34010 | 4624 |  | Tamara | [NAME]
34012 | 27140 |  | Alexis | Trahe
34013 | 27141 |  | [NAME] | Antolin
34015 | 26046 |  | [NAME] | [NAME]
34016 | 27143 |  | [NAME] | Wilson
34017 | 27144 |  | [NAME] | Gavish-Raikes
34018 | 3999 |  | Jeremiah | [NAME]
34019 | 27145 |  | Mayisha | [NAME]
34020 | 27146 |  | Nerissa | Dhanpat
34021 | 27147 |  | [NAME] | Weiler
34022 | 27148 |  | [NAME] | Sabold
34026 | 26874 |  | [NAME] | Nikoloska
34027 | 22307 | [NAME] By Nature LLC | Natalia | [NAME]
34028 | 27149 |  | [NAME] | Brink
34029 | 20603 |  | [NAME] | [NAME]
34030 | 27150 |  | Nadia | Alamah
34031 | 27151 |  | Elisheva | [NAME]
34032 | 27152 |  | Balaji | Narasimhan
34033 | 27153 | Henna by [NAME] | Amanda | Montano
34034 | 27154 |  | Yougnesse | [NAME]
34037 | 27010 | Henna by Angelica | Angelica | [NAME]
34038 | 23957 |  | [NAME] | Rimatzki
34040 | 25778 |  | [NAME] | [NAME]
34041 | 27156 |  | Dustin | Daws
34042 | 27157 |  | [NAME] | Ertzman
34043 | 27158 |  | Tara | Hupp
34044 | 27159 |  | [NAME] | Ware
34045 | 17265 | House of Henna | [NAME] | Streets
34046 | 27160 |  | Zaid | Kinariwala
34047 | 27161 |  | Marcy | Whipkins
34048 | 27162 |  | Shawn | Callaway
34049 | 27163 |  | Kristen | [NAME]