{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Using TEXTJOIN and IF Functions","Apply CONCAT and IF Functions","Employing Functions & Filter","Combine CONCATENATE & IF ","Using COUNTA and IF Functions","Applying VBA ","Using User Defined Function"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Concatenating Values If Match"]
[]
[null,"State ","Sales Person"]
[null,"Texas","Adam"]
[null,"Ohio","Eric"]
[null,"Texas","Rachel"]
[null,"Ohio","Penny"]
[null,"Texas","Jake"]
[null,"Florida","Amy"]
[null,"Florida","Kim"]
[null,"Texas","Jhon"]
[null,"Ohio","Jerry"]
[null,"Texas","Annie"]

{"sheet":"Using TEXTJOIN and IF Functions","index":1,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using TEXTJOIN and IF Functions",null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"State ","Sales Person",null,"State ","Sales Person",null,null,null,null,null,"State ","Sales Person",null,"State ","Sales Person"]
[null,"Texas","Adam",null,"Texas",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IF($B$5:$B$14=E5,$C$5:$C$14,\"\"))","v":"Adam,Rachel,Jake,Jhon,Annie"},null,null,null,null,null,"Texas","Adam",null,"Texas"]
[null,"Ohio","Eric",null,"Ohio",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IF($B$5:$B$14=E6,$C$5:$C$14,\"\"))","v":"Eric,Penny,Jerry"},null,null,null,null,null,"Ohio","Eric",null,"Ohio"]
[null,"Texas","Rachel",null,"Florida",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IF($B$5:$B$14=E7,$C$5:$C$14,\"\"))","v":"Amy,Kim"},null,null,null,null,null,"Texas","Rachel",null,"Florida"]
[null,"Ohio","Penny",null,null,null,null,null,null,null,null,"Ohio","Penny"]
[null,"Texas","Jake",null,null,null,null,null,null,null,null,"Texas","Jake"]
[null,"Florida","Amy",null,null,null,null,null,null,null,null,"Florida","Amy"]
[null,"Florida","Kim",null,null,null,null,null,null,null,null,"Florida","Kim"]
[null,"Texas","Jhon",null,null,null,null,null,null,null,null,"Texas","Jhon"]
[null,"Ohio","Jerry",null,null,null,null,null,null,null,null,"Ohio","Jerry"]
[null,"Texas","Annie",null,null,null,null,null,null,null,null,"Texas","Annie"]

{"sheet":"Apply CONCAT and IF Functions","index":2,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Applying CONCAT and IF Functions",null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"State ","Sales Person",null,"State ","Sales Person",null,null,null,null,null,"State ","Sales Person",null,"State ","Sales Person"]
[null,"Texas","Adam",null,"Texas",{"$f":"_xlfn.CONCAT(IF($B$5:$B$14=E5,$C$5:$C$14&\",\",\"\"))","v":"Adam,Rachel,Jake,Jhon,Annie,"},null,null,null,null,null,"Texas","Adam",null,"Texas"]
[null,"Ohio","Eric",null,"Ohio",{"$f":"_xlfn.CONCAT(IF($B$5:$B$14=E6,$C$5:$C$14&\",\",\"\"))","v":"Eric,Penny,Jerry,"},null,null,null,null,null,"Ohio","Eric",null,"Ohio"]
[null,"Texas","Rachel",null,"Florida",{"$f":"_xlfn.CONCAT(IF($B$5:$B$14=E7,$C$5:$C$14&\",\",\"\"))","v":"Amy,Kim,"},null,null,null,null,null,"Texas","Rachel",null,"Florida"]
[null,"Ohio","Penny",null,null,null,null,null,null,null,null,"Ohio","Penny"]
[null,"Texas","Jake",null,null,null,null,null,null,null,null,"Texas","Jake"]
[null,"Florida","Amy",null,null,null,null,null,null,null,null,"Florida","Amy"]
[null,"Florida","Kim",null,null,null,null,null,null,null,null,"Florida","Kim"]
[null,"Texas","Jhon",null,null,null,null,null,null,null,null,"Texas","Jhon"]
[null,"Ohio","Jerry",null,null,null,null,null,null,null,null,"Ohio","Jerry"]
[null,"Texas","Annie",null,null,null,null,null,null,null,null,"Texas","Annie"]

{"sheet":"Employing Functions & Filter","index":3,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Employing Functions & Filter",null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"State ","Sales Person","Concatenated","State,\"Sales Person\"",null,null,null,null,"State ","Sales Person","Concatenated","State,\"Sales Person\""]
[null,"Texas","Adam",{"$f":"IF(B5<>B4,C5,CONCATENATE(D4,\",\",C5))","v":"Adam"},{"$f":"IF(B5<>B6,CONCATENATE(B5,\",\"\"\",D5,\"\"\"\"),\"\")","v":""},null,null,null,null,"Texas","Adam"]
[null,"Texas","Rachel",{"$f":"IF(B6<>B5,C6,CONCATENATE(D5,\",\",C6))","v":"Adam,Rachel"},{"$f":"IF(B6<>B7,CONCATENATE(B6,\",\"\"\",D6,\"\"\"\"),\"\")","v":""},null,null,null,null,"Texas","Rachel"]
[null,"Texas","Jake","Adam,Rachel,Jake","",null,null,null,null,"Texas","Jake"]
[null,"Texas","Jhon","Adam,Rachel,Jake,Jhon","",null,null,null,null,"Texas","Jhon"]
[null,"Texas","Annie","Adam,Rachel,Jake,Jhon,Annie","Texas,\"Adam,Rachel,Jake,Jhon,Annie\"",null,null,null,null,"Texas","Annie"]
[null,"Ohio","Eric","Eric","",null,null,null,null,"Ohio","Eric"]
[null,"Ohio","Penny","Eric,Penny","",null,null,null,null,"Ohio","Penny"]
[null,"Ohio","Jerry","Eric,Penny,Jerry","Ohio,\"Eric,Penny,Jerry\"",null,null,null,null,"Ohio","Jerry"]
[null,"Florida","Amy","Amy","",null,null,null,null,"Florida","Amy"]
[null,"Florida","Kim","Amy,Kim","Florida,\"Amy,Kim\"",null,null,null,null,"Florida","Kim"]

{"sheet":"Combine CONCATENATE & IF ","index":4,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Combining CONCATENATE & IF Functions",null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"First Name","Middle Name","Last Name",null,"Full Name",null,null,null,null,"First Name","Middle Name","Last Name",null,"Full Name"]
[null,"Lois",null,"Turner",null,{"$f":"CONCATENATE(B5,\" \",IF(ISBLANK(C5),\"\",C5&\" \"),D5)","v":"Lois Turner"},null,null,null,null,"Lois",null,"Turner"]
[null,"Albert","Jhon","Hill",null,{"$f":"CONCATENATE(B6,\" \",IF(ISBLANK(C6),\"\",C6&\" \"),D6)","v":"Albert Jhon Hill"},null,null,null,null,"Albert","Jhon","Hill"]
[null,"Susan",null,"Tylor",null,"Susan Tylor",null,null,null,null,"Susan",null,"Tylor"]
[null,"Anne",null,"Cox",null,"Anne Cox",null,null,null,null,"Anne",null,"Cox"]
[null,"Adam","James","Lee",null,"Adam James Lee",null,null,null,null,"Adam","James","Lee"]
[null,"Barbara","Jane","Green",null,"Barbara Jane Green",null,null,null,null,"Barbara","Jane","Green"]

{"sheet":"Using COUNTA and IF Functions","index":5,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Using COUNTA and IF Functions",null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"First Name","Middle Name","Last Name",null,"Full Name",null,null,null,null,"First Name","Middle Name","Last Name",null,"Full Name"]
[null,"Lois",null,"Turner",null,{"$f":"IF(COUNTA(C5)=0,B5&\" \"&D5,B5&\" \"&C5&\" \"&D5)","v":"Lois Turner"},null,null,null,null,"Lois",null,"Turner"]
[null,"Albert","Jhon","Hill",null,{"$f":"IF(COUNTA(C6)=0,B6&\" \"&D6,B6&\" \"&C6&\" \"&D6)","v":"Albert Jhon Hill"},null,null,null,null,"Albert","Jhon","Hill"]
[null,"Susan",null,"Tylor",null,"Susan Tylor",null,null,null,null,"Susan",null,"Tylor"]
[null,"Anne",null,"Cox",null,"Anne Cox",null,null,null,null,"Anne",null,"Cox"]
[null,"Adam","James","Lee",null,"Adam James Lee",null,null,null,null,"Adam","James","Lee"]
[null,"Barbara","Jane","Green",null,"Barbara Jane Green",null,null,null,null,"Barbara","Jane","Green"]

{"sheet":"Applying VBA ","index":6,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Applying VBA ",null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"State ","Sales Person",null,"State","Sales Person",null,null,null,null,"State ","Sales Person"]
[null,"Texas","Adam",null,"Texas"," Adam, Rachel, Jake, Jhon, Annie",null,null,null,null,"Texas","Adam"]
[null,"Ohio","Eric",null,"Ohio"," Eric, Penny, Jerry",null,null,null,null,"Ohio","Eric"]
[null,"Texas","Rachel",null,"Florida"," Amy, Kim",null,null,null,null,"Texas","Rachel"]
[null,"Ohio","Penny",null,null,null,null,null,null,null,"Ohio","Penny"]
[null,"Texas","Jake",null,null,null,null,null,null,null,"Texas","Jake"]
[null,"Florida","Amy",null,null,null,null,null,null,null,"Florida","Amy"]
[null,"Florida","Kim",null,null,null,null,null,null,null,"Florida","Kim"]
[null,"Texas","Jhon",null,null,null,null,null,null,null,"Texas","Jhon"]
[null,"Ohio","Jerry",null,null,null,null,null,null,null,"Ohio","Jerry"]
[null,"Texas","Annie",null,null,null,null,null,null,null,"Texas","Annie"]

{"sheet":"Using User Defined Function","index":7,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Using User Defined Function",null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"State ","Sales Person",null,"State ","Sales Person",null,null,null,null,"State ","Sales Person",null,"State ","Sales Person"]
[null,"Texas","Adam",null,"Texas",{"$f":"CONCATENATE_IF($B$5:$B$14,E5,$C$5:$C$14,\",\")","v":"Adam,Rachel,Jake,Jhon,Annie"},null,null,null,null,"Texas","Adam",null,"Texas"]
[null,"Ohio","Eric",null,"Ohio",{"$f":"CONCATENATE_IF($B$5:$B$14,E6,$C$5:$C$14,\",\")","v":"Eric,Penny,Jerry"},null,null,null,null,"Ohio","Eric",null,"Ohio"]
[null,"Texas","Rachel",null,"Florida",{"$f":"CONCATENATE_IF($B$5:$B$14,E7,$C$5:$C$14,\",\")","v":"Amy,Kim"},null,null,null,null,"Texas","Rachel",null,"Florida"]
[null,"Ohio","Penny",null,null,null,null,null,null,null,"Ohio","Penny"]
[null,"Texas","Jake",null,null,null,null,null,null,null,"Texas","Jake"]
[null,"Florida","Amy",null,null,null,null,null,null,null,"Florida","Amy"]
[null,"Florida","Kim",null,null,null,null,null,null,null,"Florida","Kim"]
[null,"Texas","Jhon",null,null,null,null,null,null,null,"Texas","Jhon"]
[null,"Ohio","Jerry",null,null,null,null,null,null,null,"Ohio","Jerry"]
[null,"Texas","Annie",null,null,null,null,null,null,null,"Texas","Annie"]