{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","TEXTJOIN","TEXTJOIN & MATCH","UNIQUE","VBA","VBA(without Duplicates)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dataset","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Main Dataset"]
[]
[null,"Name","Product"]
[null,"John","Mobile"]
[null,"Lucy","Mobile"]
[null,"Jason","Laptop"]
[null,"John","TV"]
[null,"Jason","Laptop"]
[null,"John","Fridge"]
[null,"Jason","Headphone"]
[null,"John","Mobile"]
[null,"Lucy","AC"]

{"sheet":"TEXTJOIN","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using TEXTJOIN Function"]
[]
[null,"Name","Product",null,"Name","Product"]
[null,"John","Mobile",null,"John",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF(E5=B5:B13,C5:C13,\"\"))","v":"Mobile, TV, Fridge, Mobile"}]
[null,"Lucy","Mobile",null,"Lucy",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF(E6=B6:B14,C6:C14,\"\"))","v":"Mobile, AC"}]
[null,"Jason","Laptop",null,"Jason",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF(E7=B7:B15,C7:C15,\"\"))","v":"Laptop, Laptop, Headphone"}]
[null,"John","TV"]
[null,"Jason","Laptop"]
[null,"John","Fridge"]
[null,"Jason","Headphone"]
[null,"John","Mobile"]
[null,"Lucy","AC"]

{"sheet":"TEXTJOIN & MATCH","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using TEXTJOIN and MATCH Functions"]
[]
[null,"Name","Product",null,"Name","Product"]
[null,"John","Mobile",null,"John",{"$f":"_xlfn.TEXTJOIN(\",\", TRUE, IF(IFERROR(MATCH(C5:C13,\nIF(E5=B5:B13, C5:C13, \"\"), 0),\"\")\n=MATCH(ROW(C5:C13), ROW(C5:C13)), C5:C13, \"\"))","v":"Mobile,TV,Fridge"}]
[null,"Lucy","Mobile",null,"Lucy",{"$f":"_xlfn.TEXTJOIN(\",\", TRUE, IF(IFERROR(MATCH(C6:C14,\nIF(E6=B6:B14, C6:C14, \"\"), 0),\"\")\n=MATCH(ROW(C6:C14), ROW(C6:C14)), C6:C14, \"\"))","v":"Mobile,AC"}]
[null,"Jason","Laptop",null,"Jason",{"$f":"_xlfn.TEXTJOIN(\",\", TRUE, IF(IFERROR(MATCH(C7:C15,\nIF(E7=B7:B15, C7:C15, \"\"), 0),\"\")\n=MATCH(ROW(C7:C15), ROW(C7:C15)), C7:C15, \"\"))","v":"Laptop,Headphone"}]
[null,"John","TV"]
[null,"Jason","Laptop"]
[null,"John","Fridge"]
[null,"Jason","Headphone"]
[null,"John","Mobile"]
[null,"Lucy","AC"]

{"sheet":"UNIQUE","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using TEXTJOIN and UNIQUE Functions"]
[]
[null,"Name","Product",null,"Name","Product"]
[null,"John","Mobile",null,"John",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF(E5=B5:B13,C5:C13,\"\")))","v":"Mobile, TV, Fridge"}]
[null,"Lucy","Mobile",null,"Lucy",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF(E6=B6:B14,C6:C14,\"\")))","v":"Mobile, AC"}]
[null,"Jason","Laptop",null,"Jason",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF(E7=B7:B15,C7:C15,\"\")))","v":"Laptop, Headphone"}]
[null,"John","TV"]
[null,"Jason","Laptop"]
[null,"John","Fridge"]
[null,"Jason","Headphone"]
[null,"John","Mobile"]
[null,"Lucy","AC"]

{"sheet":"VBA","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using VBA Codes"]
[]
[null,"Name","Product",null,"Name","Product"]
[null,"John","Mobile",null,"John",{"$f":"MultipleValues(B5:B13,E5,C5:C13,\",\")","v":"Mobile,TV,Fridge,Mobile"}]
[null,"Lucy","Mobile",null,"Lucy",{"$f":"MultipleValues(B6:B14,E6,C6:C14,\",\")","v":"Mobile,AC"}]
[null,"Jason","Laptop",null,"Jason",{"$f":"MultipleValues(B7:B15,E7,C7:C15,\",\")","v":"Laptop,Laptop,Headphone"}]
[null,"John","TV"]
[null,"Jason","Laptop"]
[null,"John","Fridge"]
[null,"Jason","Headphone"]
[null,"John","Mobile"]
[null,"Lucy","AC"]

{"sheet":"VBA(without Duplicates)","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using VBA Codes (without duplicates)"]
[]
[null,"Name","Product",null,"Name","Product"]
[null,"John","Mobile",null,"John",{"$f":"ValuesNoDup(E5,B5:B13,2)","v":" Mobile, TV, Fridge"}]
[null,"Lucy","Mobile",null,"Lucy",{"$f":"ValuesNoDup(E6,B6:B14,2)","v":" Mobile, AC"}]
[null,"Jason","Laptop",null,"Jason",{"$f":"ValuesNoDup(E7,B7:B15,2)","v":" Laptop, Headphone"}]
[null,"John","TV"]
[null,"Jason","Laptop"]
[null,"John","Fridge"]
[null,"Jason","Headphone"]
[null,"John","Mobile"]
[null,"Lucy","AC"]