Spreadsheet: 755693d1637041100-grouping-multiple-ids-into-one-column-of-data-example-5-
Sheet: Sheet1

How Spreadsheet Currently Looks:
User ID | Trip ID | Trip Date | Channel | Retailer | [NAME] | Parent Brand | Brand | UPC | Item Description | Variety Formula | Category | Manually Calculated Converted Buyer? | Units Per Trip | Spend Per Unit | Spend Per Trip | Basket [NAME] (Units) | Basket Size ($)
57 | 12332353 | 2014-03-01 00:00:00 | mass | walmart | walmart | samuel_adams | samuel_adams | 00087692100126 | [NAME] 6pk 12oz | #N/A | Regular |  | 1 | 7.64 | 7.64 | 13 | 70.69
147 | 13165118 | 2014-03-17 00:00:00 | food | save_mart | save_mart | samuel_adams | samuel_adams |  | [NAME] | #N/A | Regular |  | 1 | 16.99 | 16.99 | 13 | 62.62
147 | 13025105 | 2014-03-11 00:00:00 | food | save_mart | save_mart | samuel_adams | samuel_adams |  | [NAME] | #N/A | Regular |  | 1 | 13.99 | 13.99 | 5 | 32.93
187 | 14574815 | 2014-04-12 00:00:00 | food | kroger | frys_marketplace | samuel_adams | samuel_adams |  | [NAME] | #N/A | Regular |  | 1 | 12.99 | 12.99 | 35 | 81.47
319 | 20530738 | 2014-07-26 00:00:00 | mass | walmart | walmart | samuel_adams | samuel_adams | 00087692291039 | [NAME] Pk 12pk 12oz | Variety | Variety | Did Not Convert to Regular Pack | 1 | 13.88 | 13.88 | 14 | 101.6
329 | 17331478 | 2014-06-04 00:00:00 | food | publix | publix | samuel_adams | samuel_adams | 00087692300502 | [NAME] Seasonal 6pk 12oz | #N/A | Regular |  | 1 | 8.99 | 8.99 | 35 | 111.12
438 | 26315851 | 2014-10-02 00:00:00 | food | harris_teeter | harris_teeter | samuel_adams | samuel_adams |  | [NAME] ADAMS SEASONAL | #N/A | Regular |  | 1 | 2.99 | 2.99 | 29 | 76.82
460 | 11818788 | 2014-02-18 00:00:00 | other | lakes_wine_and_cheese | lakes_wine_and_cheese | samuel_adams | samuel_adams |  | [NAME] | #N/A | Regular |  | 1 | 11.99 | 11.99 | 2 | 22.03
846 | 8731340 | 2013-12-13 00:00:00 | club | bjs_wholesale | bjs | samuel_adams | samuel_adams | 00087692291060 | [NAME] 24pk 12oz | Variety | Variety | Did Not Convert to Regular Pack | 1 | 26.99 | 26.99 | 37 | 420.96
915 | 6854473 | 2013-11-16 00:00:00 | club | costco | costco | samuel_adams | samuel_adams |  | S ADAMS WNTR | #N/A | Regular |  | 1 | 25.99 | 25.99 | 14 | 175.67
2277 | 10454113 | 2014-01-21 00:00:00 | mass | walmart | walmart | samuel_adams | samuel_adams | 00087692300502 | [NAME] Seasonal 6pk 12oz | #N/A | Regular |  | 1 | 7.97 | 7.97 | 19 | 57.4
2277 | 19217016 | 2014-07-06 00:00:00 | mass | walmart | walmart | samuel_adams | samuel_adams | 00087692921028 | [NAME] 6pk 12oz | #N/A | Regular |  | 1 | 8.28 | 8.28 | 6 | 28.32
2415 | 28152551 | 2014-10-16 00:00:00 | food | harris_teeter | harris_teeter | samuel_adams | samuel_adams |  | [NAME] OCT | #N/A | Regular |  | 1 | 8.99 | 8.99 | 17 | 49.25
2461 | 7390061 | 2013-11-24 00:00:00 | food | albertsons | shaws | samuel_adams | samuel_adams | 00087692302001 | [NAME] Seasonal 22oz | #N/A | Regular |  | 1 | 3.49 | 3.49 | 11 | 23.6
2893 | 17823474 | 2014-06-14 00:00:00 | food | key_food | key_food | samuel_adams | samuel_adams |  | [NAME] | #N/A | Regular |  | 1 | 10.59 | 10.59 | 8 | 37.29
3299 | 7402535 | 2013-11-26 00:00:00 | food | raleys | raleys | samuel_adams | samuel_adams |  | [NAME] ADAMS SEASONAL | #N/A | Regular |  | 1 | 14.99 | 14.99 | 18 | 51.23
3299 | 19326989 | 2014-07-03 00:00:00 | food | raleys | raleys | samuel_adams | samuel_adams |  | [NAME] | #N/A | Regular |  | 1 | 12.99 | 12.99 | 24 | 82.38
3299 | 26577704 | 2014-09-24 00:00:00 | drug | riteaid | rite_aid | samuel_adams | samuel_adams |  | S ADMS WD CLS 12Z 12PK LN | #N/A | Regular |  | 1 | 11.99 | 11.99 | 3 | 19.71
3299 | 24907865 | 2014-09-07 00:00:00 | food | raleys | raleys | samuel_adams | samuel_adams |  | [NAME] | #N/A | Regular |  | 1 | 13.99 | 13.99 | 3 | 17.86
3346 | 17802591 | 2014-05-31 00:00:00 | mass | walmart | walmart | samuel_adams | samuel_adams | 00087692011033 | [NAME] Seasonal 12pk 12oz | #N/A | Regular |  | 1 | 14.47 | 14.47 | 4 | 25.68
3819 | 18542280 | 2014-06-27 00:00:00 | food | giant_eagle | giant_eagle | samuel_adams | samuel_adams |  | [NAME] SEASONAL NP | #N/A | Regular |  | 1 | 14.99 | 14.99 | 7 | 74.53
5624 | 7488914 | 2013-11-26 00:00:00 | mass | walmart | walmart | samuel_adams | samuel_adams | 00087692300502 | [NAME] Seasonal 6pk 12oz | #N/A | Regular |  | 1 | 8.28 | 8.28 | 10 | 34.95
5624 | 7485878 | 2013-11-16 00:00:00 | food | kroger | kroger | samuel_adams | samuel_adams |  | [NAME] | #N/A | Regular |  | 1 | 8.99 | 8.99 | 52 | 153.04
5987 | 8281971 | 2013-12-10 00:00:00 | food | safeway | safeway | samuel_adams | samuel_adams |  | [NAME] SEASONAL | #N/A | Regular |  | 1 | 9.99 | 9.99 | 8 | 42.8
6457 | 21249486 | 2014-08-04 00:00:00 | food | kroger | kroger | samuel_adams | samuel_adams |  | [NAME] | #N/A | Regular |  | 1 | 14.99 | 14.99 | 40 | 89.82
35197 | 18148875 | 2014-06-20 00:00:00 | mass | target | target | samuel_adams | samuel_adams | 00087692001270 | [NAME] IPA 6pk 12oz | #N/A | Regular |  | 1 | 10.79 | 10.79 | 31 | 136.31
35197 | 9996392 | 2014-01-12 00:00:00 | mass | walmart | walmart | samuel_adams | samuel_adams | 00087692291039 | [NAME] Pk 12pk 12oz | Variety | Variety | Converted to Regular Pack | 2 | 13.97 | 27.94 | 121 | 391.86
35197 | 12000812 | 2014-02-23 00:00:00 | mass | walmart | walmart | samuel_adams | samuel_adams | 00087692291039 | [NAME] Pk 12pk 12oz | Variety | Variety |  | 1 | 14.88 | 14.88 | 82 | 410.84
35197 | 16202246 | 2014-05-07 00:00:00 | mass | walmart | walmart | samuel_adams | samuel_adams | 00087692291039 | [NAME] Pk 12pk 12oz | Variety | Variety |  | 1 | 14.88 | 14.88 | 58 | 326.39
35197 | 10800764 | 2014-01-29 00:00:00 | food | bi_lo | bi_lo | samuel_adams | samuel_adams |  | ADAMS SEASN 6PK | #N/A | Regular |  | 1 | 8.79 | 8.79 | 34 | 128.66
35197 | 16604252 | 2014-05-17 00:00:00 | food | delhaize | food_lion | samuel_adams | samuel_adams |  | 12PK NR S/ADAMS SE | #N/A | Regular |  | 1 | 11.99 | 11.99 | 34 | 135.07
How I want Spreadsheet to Look:
User ID | Trip ID | Trip Date | Channel | Retailer | [NAME] | Parent Brand | Brand | UPC | Item Description | Variety Formula | Category |  |  |  |  |  |  |  | User ID | Category
57 |  |  |  |  |  |  |  |  |  |  | Regular |  |  |  |  |  |  |  |  |  |  | =CHOOSE(IF(SUMPRODUCT(($A$4:$A$34=T40)*($L$4:$L$34="Regular"))>0,1,)+IF(SUMPRODUCT(($A$4:$A$34=T40)*($L$4:$L$34="Variety"))>0,2,0),"Regular","Variety","Regular & Variety")
147 |  |  |  |  |  |  |  |  |  |  | Regular |  |  |  |  |  |  |  | 147
187 |  |  |  |  |  |  |  |  |  |  | Regular |  |  |  |  |  |  |  | 187
319 | 20530738 | 2014-07-26 00:00:00 | mass | walmart | walmart | samuel_adams | samuel_adams | 00087692291039 | [NAME] Pk 12pk 12oz | Variety | Variety |  |  |  |  |  |  |  | 319
329 | 17331478 | 2014-06-04 00:00:00 | food | publix | publix | samuel_adams | samuel_adams | 00087692300502 | [NAME] Seasonal 6pk 12oz | #N/A | Regular |  |  |  |  |  |  |  | 329
438 | 26315851 | 2014-10-02 00:00:00 | food | harris_teeter | harris_teeter | samuel_adams | samuel_adams |  | [NAME] ADAMS SEASONAL | #N/A | Regular |  |  |  |  |  |  |  | 438
460 | 11818788 | 2014-02-18 00:00:00 | other | lakes_wine_and_cheese | lakes_wine_and_cheese | samuel_adams | samuel_adams |  | [NAME] | #N/A | Regular |  |  |  |  |  |  |  | 460
846 | 8731340 | 2013-12-13 00:00:00 | club | bjs_wholesale | bjs | samuel_adams | samuel_adams | 00087692291060 | [NAME] 24pk 12oz | Variety | Variety |  |  |  |  |  |  |  | 846
5624 |  |  |  |  |  |  |  |  |  |  | Regular |  |  |  |  |  |  |  | 915
5987 | 8281971 | 2013-12-10 00:00:00 | food | safeway | safeway | samuel_adams | samuel_adams |  | [NAME] SEASONAL | #N/A | Regular |  |  |  |  |  |  |  | 2277
6457 | 21249486 | 2014-08-04 00:00:00 | food | kroger | kroger | samuel_adams | samuel_adams |  | [NAME] | #N/A | Regular |  |  |  |  |  |  |  | 2415
35197 | 18148875 | 2014-06-20 00:00:00 | mass | target | target | samuel_adams | samuel_adams | 00087692001270 | [NAME] IPA 6pk 12oz | #N/A | Regular & Variety |  |  |  |  |  |  |  | 2461
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2893
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3299
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3346
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3819
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5624
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5987
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6457
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35197