Spreadsheet: 155116d1336672641-converting-multiple-sets-of-rows-to-a-single-row-example
Sheet: before

Name | Birth date | Cust # | H or M | [NAME] | Order Total | Ship Date | Tracking # | phone | phone 2 | fax | Other
RICHARDS, ROBERT N | 1985-10-30 00:00:00 | ILD4714E | M | 20 | 163 | 2012-01-03 00:00:00 | 6014988586 | 1383860418 | 4308125325 | 2688699779 | 2
RICHARDS, ROBERT N | 1985-10-30 00:00:00 | ILD4714E | M | 7 | 354 | 2011-10-09 00:00:00 | 1840515674 | 7126620155 | 4745390203 | 7334265844 | 38
RICHARDS, ROBERT N | 1985-10-30 00:00:00 | ILD4714E | M | 5 | 322 | 2011-06-07 00:00:00 | 7965441650 | 6642886488 | 5872514179 | 4335513102 | 41
HORSEMAN, ROSA M | 1963-03-05 00:00:00 | MXX3495C | H | 11 | 42 | 2011-06-08 00:00:00 | 1094926239 | 4345625993 | 6611977007 | 6563550835 | 26
HORSEMAN, ROSA M | 1963-03-05 00:00:00 | MXX3495C | H | 9 | 206 | 2011-06-09 00:00:00 | 3904255266 | 1481819134 | 2690397875 | 1546743646 | 15
HORSEMAN, ROSA M | 1963-03-05 00:00:00 | MXX3495C | M | 13 | 176 | 2011-06-10 00:00:00 | 5404463549 | 7644028052 | 1450198516 | 4015202335 | 38
HORSEMAN, ROSA M | 1963-03-05 00:00:00 | MXX3495C | M | 9 | 173 | 2011-06-11 00:00:00 | 3809666780 | 1359441169 | 3353123390 | 2728869047 | 40
HORSEMAN, ROSA M | 1963-03-05 00:00:00 | MXX3495C | M | 2 | 227 | 2011-06-12 00:00:00 | 1302872858 | 4457524656 | 3893250956 | 2692583149 | 24
HORSEMAN, ROSA M | 1963-03-05 00:00:00 | MXX3495C | M | 4 | 360 | 2011-06-13 00:00:00 | 7790726904 | 5200105911 | 2697013468 | 6777598607 | 5
HORSEMAN, ROSA M | 1963-03-05 00:00:00 | MXX3495C | M | 6 | 201 | 2011-06-14 00:00:00 | 1194988931 | 5066469949 | 3095384507 | 3097684047 | 9
HORSEMAN, ROSA M | 1963-03-05 00:00:00 | MXX3495C | M | 14 | 139 | 2011-06-15 00:00:00 | 1890826314 | 4963908508 | 3389606388 | 5689208312 | 36
LISA, TONI S | 1948-10-06 00:00:00 | SP300P5W | H | 14 | 177 | 2011-06-16 00:00:00 | 4486607982 | 2351265618 | 3605825395 | 5522566466 | 29
LISA, TONI S | 1948-10-06 00:00:00 | SP300P5W | H | 6 | 172 | 2011-06-17 00:00:00 | 1462946787 | 3574135240 | 1891544822 | 1821589273 | 18
LISA, TONI S | 1948-10-06 00:00:00 | SP300P5W | H | 13 | 27 | 2011-06-18 00:00:00 | 6756070661 | 5186333454 | 2076506151 | 4431812940 | 26
LISA, TONI S | 1948-10-06 00:00:00 | SP300P5W | H | 14 | 352 | 2011-06-19 00:00:00 | 5863083236 | 4767429857 | 5844078332 | 3605922138 | 11
LISA, TONI S | 1948-10-06 00:00:00 | SP300P5W | H | 17 | 226 | 2011-06-20 00:00:00 | 9189908165 | 6776724953 | 1697013797 | 6375117588 | 17
LISA, TONI S | 1948-10-06 00:00:00 | SP300P5W | M | 12 | 174 | 2011-06-21 00:00:00 | 1559810227 | 5777559166 | 6027224382 | 1387522228 | 20
MANN, BRADLEY J | 1962-02-01 00:00:00 | ET201B2I | M | 13 | 192 | 2011-06-22 00:00:00 | 4024996031 | 6832672025 | 3184236280 | 4689414118 | 18
MANN, BRADLEY J | 1962-02-01 00:00:00 | ET201B2I | M | 8 | 136 | 2011-06-23 00:00:00 | 4535524332 | 3934038145 | 1704197287 | 7038378815 | 13
MANN, BRADLEY J | 1962-02-01 00:00:00 | ET201B2I | M | 20 | 130 | 2011-06-24 00:00:00 | 9906802274 | 3031482517 | 3414206382 | 1977356418 | 1
MANN, BRADLEY J | 1962-02-01 00:00:00 | ET201B2I | M | 18 | 209 | 2011-06-25 00:00:00 | 6707477559 | 2805223464 | 1798537854 | 6989184599 | 27
MANN, BRADLEY J | 1962-02-01 00:00:00 | ET201B2I | M | 6 | 117 | 2011-06-26 00:00:00 | 6878658067 | 2900221736 | 4517455053 | 6450409878 | 45
MANN, BRADLEY J | 1962-02-01 00:00:00 | ET201B2I | M | 13 | 187 | 2011-06-27 00:00:00 | 5902724413 | 2626705802 | 7585762327 | 3977961337 | 11
[NAME], [NAME] | 1948-07-18 00:00:00 | AG72680B | H | 12 | 114 | 2011-06-28 00:00:00 | 2798169681 | 4114307441 | 2096313985 | 5840210869 | 9
[NAME], [NAME] | 1948-07-18 00:00:00 | AG72680B | H | 14 | 198 | 2011-06-29 00:00:00 | 4827011928 | 1704563764 | 5766729107 | 4137720521 | 27
[NAME], [NAME] | 1948-07-18 00:00:00 | AG72680B | H | 15 | 186 | 2011-06-30 00:00:00 | 3706001290 | 7152420131 | 7169853488 | 5316084524 | 6
[NAME], [NAME] | 1948-07-18 00:00:00 | AG72680B | H | 12 | 26 | 2011-07-01 00:00:00 | 8159144356 | 1233316926 | 2232723381 | 1488542514 | 5
[NAME], [NAME] | 1948-07-18 00:00:00 | AG72680B | H | 12 | 195 | 2011-07-02 00:00:00 | 3432731074 | 4197913419 | 4573824262 | 7092917365 | 49
[NAME], [NAME] | 1948-07-18 00:00:00 | AG72680B | H | 5 | 177 | 2011-07-03 00:00:00 | 3373655035 | 6245969776 | 5540795035 | 5360913467 | 45
[NAME], [NAME] | 1948-07-18 00:00:00 | AG72680B | H | 18 | 156 | 2011-07-04 00:00:00 | 7913695619 | 3726883371 | 2258799548 | 7281091733 | 51
[NAME], [NAME] | 1948-07-18 00:00:00 | AG72680B | M | 5 | 72 | 2011-07-05 00:00:00 | 3580165504 | 4752891821 | 7514439593 | 3189990077 | 18
[NAME], [NAME] | 1948-07-18 00:00:00 | AG72680B | M | 13 | 128 | 2011-07-06 00:00:00 | 7546524093 | 6613022941 | 1545191368 | 7361278603 | 32
[NAME], [NAME] | 1948-07-18 00:00:00 | AG72680B | M | 4 | 48 | 2011-07-07 00:00:00 | 3268785759 | 4000348606 | 2539685607 | 6381753070 | 24
[NAME], [NAME] | 1948-07-18 00:00:00 | AG72680B | M | 16 | 218 | 2011-07-08 00:00:00 | 4898002027 | 3118134835 | 1591140019 | 5309625654 | 25
[NAME], [NAME] | 1948-07-18 00:00:00 | AG72680B | M | 19 | 136 | 2011-07-09 00:00:00 | 4476260499 | 3089916897 | 4781459078 | 7536527887 | 51
FIELD, LAURA R | 1969-07-22 00:00:00 | BL32815A | M | 16 | 58 | 2011-07-10 00:00:00 | 7874655239 | 1600219982 | 3805949666 | 4912493233 | 37
FIELD, LAURA R | 1969-07-22 00:00:00 | BL32815A | M | 12 | 53 | 2011-07-11 00:00:00 | 3372592322 | 7423619744 | 7011498216 | 3571781791 | 10
FIELD, LAURA R | 1969-07-22 00:00:00 | BL32815A | M | 3 | 202 | 2011-07-12 00:00:00 | 4999392846 | 2251559730 | 1991520212 | 5743563245 | 5
FIELD, LAURA R | 1969-07-22 00:00:00 | BL32815A | M | 11 | 145 | 2011-07-13 00:00:00 | 6411591349 | 3226083847 | 3772724269 | 4808720715 | 43
FIELD, LAURA R | 1969-07-22 00:00:00 | BL32815A | M | 12 | 195 | 2011-07-14 00:00:00 | 7890218541 | 4578867793 | 5664283593 | 7485309679 | 34
DOE, [NAME] | 1949-03-05 00:00:00 | VJ000W0J | H | 17 | 59 | 2011-07-15 00:00:00 | 4966667478 | 3056367537 | 4312456981 | 7009232838 | 36
DOE, [NAME] | 1949-03-05 00:00:00 | VJ000W0J | H | 14 | 215 | 2011-07-16 00:00:00 | 4994149544 | 2178757731 | 1645240722 | 7064929121 | 6
DOE, [NAME] | 1949-03-05 00:00:00 | VJ000W0J | H | 12 | 163 | 2011-07-17 00:00:00 | 4868967642 | 1989040257 | 6047602091 | 6429389037 | 22
DOE, [NAME] | 1949-03-05 00:00:00 | VJ000W0J | H | 20 | 110 | 2011-07-18 00:00:00 | 7882597637 | 5733442112 | 2196687580 | 4691682794 | 5
DOE, [NAME] | 1949-03-05 00:00:00 | VJ000W0J | H | 19 | 43 | 2011-07-19 00:00:00 | 9464284374 | 6279791621 | 5394233396 | 6887482745 | 17
DOE, [NAME] | 1949-03-05 00:00:00 | VJ000W0J | H | 8 | 44 | 2011-07-20 00:00:00 | 9451608676 | 4695413557 | 5754782664 | 3843312243 | 20
DOE, [NAME] | 1949-03-05 00:00:00 | VJ000W0J | M | 13 | 16 | 2011-07-21 00:00:00 | 3013236262 | 4685742174 | 4359043719 | 6692450465 | 23
JACOBSON, CHANTEL M | 1979-12-01 00:00:00 | AZ95778B | H | 8 | 149 | 2011-07-22 00:00:00 | 9978884613 | 5901194712 | 4440554247 | 3187640768 | 30
JACOBSON, CHANTEL M | 1979-12-01 00:00:00 | AZ95778B | H | 9 | 72 | 2011-07-23 00:00:00 | 7508148487 | 1584883856 | 6859656011 | 3513116056 | 46
JACOBSON, CHANTEL M | 1979-12-01 00:00:00 | AZ95778B | H | 13 | 209 | 2011-07-24 00:00:00 | 9763566319 | 3511941592 | 2210611960 | 6997163591 | 41
JACOBSON, CHANTEL M | 1979-12-01 00:00:00 | AZ95778B | H | 2 | 109 | 2011-07-25 00:00:00 | 2467625406 | 3348338172 | 3292772022 | 5961940983 | 23
JACOBSON, CHANTEL M | 1979-12-01 00:00:00 | AM13525B | H | 3 | 87 | 2011-07-26 00:00:00 | 8200171866 | 6743112119 | 1642635518 | 2296446306 | 25
JACOBSON, CHANTEL M | 1979-12-01 00:00:00 | AZ95778B | H | 16 | 21 | 2011-07-27 00:00:00 | 4714594462 | 7572827839 | 3051959487 | 2156134554 | 25
JACOBSON, CHANTEL M | 1979-12-01 00:00:00 | AZ95778B | M | 17 | 132 | 2011-07-28 00:00:00 | 3663462376 | 2405439607 | 4619845231 | 3167754091 | 50
JACOBSON, CHANTEL M | 1979-12-01 00:00:00 | AZ95778B | M | 7 | 78 | 2011-07-29 00:00:00 | 7468728982 | 3911020443 | 2866170818 | 5493382514 | 48
JACOBSON, CHANTEL M | 1979-12-01 00:00:00 | AZ95778B | M | 4 | 23 | 2011-07-30 00:00:00 | 1963465719 | 3606202455 | 4392933029 | 5957311097 | 6
LAWSON, AMY | 1958-05-21 00:00:00 | DE75460A | H | 2 | 188 | 2011-07-31 00:00:00 | 4043186189 | 5036725210 | 4151112954 | 7586251780 | 21
LAWSON, AMY | 1958-05-21 00:00:00 | DE75460A | H | 7 | 182 | 2011-08-01 00:00:00 | 6463603333 | 2934433964 | 5477239043 | 3284162449 | 5
LAWSON, AMY | 1958-05-21 00:00:00 | DE75460A | H | 15 | 144 | 2011-08-02 00:00:00 | 3402813370 | 7534333984 | 7296902615 | 1558924905 | 29
LAWSON, AMY | 1958-05-21 00:00:00 | DE75460A | H | 9 | 52 | 2011-08-03 00:00:00 | 1702748435 | 5775331464 | 6253272821 | 2793894273 | 12
LAWSON, AMY | 1958-05-21 00:00:00 | DE75460A | H | 2 | 52 | 2011-08-04 00:00:00 | 4673871996 | 7561968663 | 7178830676 | 5321765494 | 4
LAWSON, AMY | 1958-05-21 00:00:00 | DE75460A | M | 19 | 221 | 2011-08-05 00:00:00 | 1235008634 | 7606681511 | 7230841667 | 3766621946 | 11