{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset","&","&_IF","CONCATENATE","CONCAT","TRANSPOSE","TEXTJOIN","IF_TEXTJOIN","OFFSET","Fill","Power_Query","Power Query Output","VBA"],"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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null," Constructing Sentence with Words "]
[]
[null,"Words","Sentence"]
[null,"Practice"]
[null,"makes"]
[null,"a"]
[null,"man"]
[null,"perfect"]

{"sheet":"&","index":1,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,11,2,12],[5,2,9,2]]}
[]
[]
[null," Constructing Sentence with Words ",null,null,null,null,null,null,null,null,null," Constructing Sentence with Words "]
[]
[null,"Words","Sentence",null,null,null,null,null,null,null,null,"Words","Sentence"]
[null,"Practice",{"$f":"B6&\" \"&B7&\" \"&B8&\" \"&B9&\" \"&B10","v":"Practice makes a man perfect"},null,null,null,null,null,null,null,null,"Practice"]
[null,"makes",null,null,null,null,null,null,null,null,null,"makes"]
[null,"a",null,null,null,null,null,null,null,null,null,"a"]
[null,"man",null,null,null,null,null,null,null,null,null,"man"]
[null,"perfect",null,null,null,null,null,null,null,null,null,"perfect"]

{"sheet":"&_IF","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,5,2,7]]}
[]
[]
[null,"Player from Same Sport",null,null,null,"Player from Same Sport"]
[]
[null,"Sports","Player Name","Together",null,"Sports","Player Name","Together"]
[null,"Cricket","John",{"$f":"IF(B6=B5,D5&\",\"&C6,C6)","v":"John"},null,"Cricket","John",{"$f":"IF(F6=F5,H5&\",\"&G6,G6)","v":"John"}]
[null,"Cricket","Tom",{"$f":"IF(B7=B6,D6&\",\"&C7,C7)","v":"John,Tom"},null,"Cricket","Tom",{"$f":"IF(F7=F6,H6&\",\"&G7,G7)","v":"John,Tom"}]
[null,"Cricket","Ron","John,Tom,Ron",null,"Cricket","Ron","John,Tom,Ron"]
[null,"Cricket","Sam","John,Tom,Ron,Sam",null,"Cricket","Sam","John,Tom,Ron,Sam"]
[null,"Football","Jessica","Jessica",null,"Football","Jessica","Jessica"]
[null,"Football","Hana","Jessica,Hana",null,"Football","Hana","Jessica,Hana"]

{"sheet":"CONCATENATE","index":3,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,11,2,12],[5,2,9,2]]}
[]
[]
[null," Constructing Sentence with Words ",null,null,null,null,null,null,null,null,null," Constructing Sentence with Words "]
[]
[null,"Words","Sentence",null,null,null,null,null,null,null,null,"Words","Sentence"]
[null,"Practice",{"$f":"CONCATENATE(B6,\" \",B7,\" \",B8,\" \",B9,\" \",B10)","v":"Practice makes a man perfect"},null,null,null,null,null,null,null,null,"Practice"]
[null,"makes",null,null,null,null,null,null,null,null,null,"makes"]
[null,"a",null,null,null,null,null,null,null,null,null,"a"]
[null,"man",null,null,null,null,null,null,null,null,null,"man"]
[null,"perfect",null,null,null,null,null,null,null,null,null,"perfect"]

{"sheet":"CONCAT","index":4,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,11,2,12],[5,2,7,2]]}
[]
[]
[null," Constructing Address ",null,null,null,null,null,null,null,null,null," Constructing Address"]
[]
[null,"Words","Full Address",null,null,null,null,null,null,null,null,"Words","Full Address"]
[null,"Dhanmondi,",{"$f":"_xlfn.CONCAT(B6:B8)","v":"Dhanmondi,27,Dhaka"},null,null,null,null,null,null,null,null,"Dhanmondi,"]
[null,"27,",null,null,null,null,null,null,null,null,null,"27,"]
[null,"Dhaka",null,null,null,null,null,null,null,null,null,"Dhaka"]

{"sheet":"TRANSPOSE","index":5,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,11,2,12],[5,2,7,2]]}
[]
[]
[null," Constructing Address ",null,null,null,null,null,null,null,null,null," Constructing Address "]
[]
[null,"Words","Sentence",null,null,null,null,null,null,null,null,"Words","Sentence"]
[null,"Dhanmondi,",{"$f":"CONCATENATE(221,\"Baker\",\"Street\")","v":"221BakerStreet"},null,null,null,null,null,null,null,null,"Dhanmondi,",{"$f":"CONCATENATE(221,\"Baker\",\"Street\")","v":"221BakerStreet"}]
[null,"27,",null,null,null,null,null,null,null,null,null,"27,"]
[null,"Dhaka",null,null,null,null,null,null,null,null,null,"Dhaka"]

{"sheet":"TEXTJOIN","index":6,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12],[4,2,8,2]]}
[]
[null," Constructing Sentence with Words ",null,null,null,null,null,null,null,null,null," Constructing Sentence with Words "]
[]
[null,"Words","Sentence",null,null,null,null,null,null,null,null,"Words","Sentence"]
[null,"Practice",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B5:B9)","v":"Practice makes a man perfect"},null,null,null,null,null,null,null,null,"Practice",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,L5:L9)","v":"Practice makes a man perfect"}]
[null,"makes",null,null,null,null,null,null,null,null,null,"makes"]
[null,"a",null,null,null,null,null,null,null,null,null,"a"]
[null,"man",null,null,null,null,null,null,null,null,null,"man"]
[null,"perfect",null,null,null,null,null,null,null,null,null,"perfect"]

{"sheet":"IF_TEXTJOIN","index":7,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,11,2,13],[5,3,7,3],[8,3,10,3],[5,1,7,1],[8,1,10,1]]}
[]
[]
[null,"Player from Same Sport",null,null,null,null,null,null,null,null,null,"Player from Same Sport"]
[]
[null,"Sports","Player Name","Together",null,null,null,null,null,null,null,"Sports","Player Name","Together"]
[null,"Cricket","John",{"$f":"IF(B6=\"\",\"\",_xlfn.TEXTJOIN(\", \",TRUE,C6:C8))","v":"John, Tom, Ron"},null,null,null,null,null,null,null,"Citrus Fruits","Lemon"]
[null,null,"Tom",null,null,null,null,null,null,null,null,null,"Orange"]
[null,null,"Ron",null,null,null,null,null,null,null,null,null,"Lime"]
[null,"Football","Sam",{"$f":"IF(B9=\"\",\"\",_xlfn.TEXTJOIN(\", \",TRUE,C9:C11))","v":"Sam, Jessica, Hana"},null,null,null,null,null,null,null,"Dry Fruits","Dates"]
[null,null,"Jessica",null,null,null,null,null,null,null,null,null,"Raisins"]
[null,null,"Hana",null,null,null,null,null,null,null,null,null,"Apricots"]

{"sheet":"OFFSET","index":8,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,11,2,13],[5,3,7,3],[8,3,10,3]]}
[]
[]
[null,"Player from Same Sport",null,null,null,null,null,null,null,null,null,"Player from Same Sport"]
[]
[null,"Sports","Player Name","Together",null,null,null,null,null,null,null,"Sports","Player Name","Together"]
[null,"Cricket","John",{"$f":"IF(B6=B5,\"\",_xlfn.TEXTJOIN(\", \",TRUE,OFFSET(C6,0,0,\nCOUNTIF(B:B,B6),1)))","v":"John, Tom, Ron"},null,null,null,null,null,null,null,"Cricket","John"]
[null,"Cricket","Tom",null,null,null,null,null,null,null,null,"Cricket","Tom"]
[null,"Cricket","Ron",null,null,null,null,null,null,null,null,"Cricket","Ron"]
[null,"Football","Sam","Sam, Jessica, Hana",null,null,null,null,null,null,null,"Football","Sam"]
[null,"Football","Jessica",null,null,null,null,null,null,null,null,"Football","Jessica"]
[null,"Football","Hana",null,null,null,null,null,null,null,null,"Football","Hana",{"$f":"IF(L11=L10,\"\",_xlfn.TEXTJOIN(\", \",TRUE,OFFSET(M11,0,0,\nCOUNTIF(L:L,L11),1)))","v":""}]

{"sheet":"Fill","index":9,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[5,2,9,2]]}
[]
[]
[null," Constructing Sentence with Words "]
[]
[null,"Words","Sentence"]
[null,"Practice","Practice makes a man perfect"]
[null,"makes"]
[null,"a"]
[null,"man"]
[null,"perfect"]

{"sheet":"Power_Query","index":10,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null," Constructing Sentence with Words "]
[]
[null,"Words"]
[null,"Practice"]
[null,"makes"]
[null,"a"]
[null,"man"]
[null,"perfect"]

{"sheet":"Power Query Output","index":11,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Concatenated"]
["Practice makes a man perfect"]

{"sheet":"VBA","index":12,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[5,2,9,2]]}
[]
[]
[null," Constructing Sentence with Words "]
[]
[null,"Words","Sentence"]
[null,"Practice","Practice makes a man perfect"]
[null,"makes"]
[null,"a"]
[null,"man"]
[null,"perfect"]