{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["CONCAT Function","TEXTJOIN Function","Concatenate Method","CONCAT and TRANSPOSE Functions","VBA Code"],"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":"CONCAT Function","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using CONCAT Function",null,null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID","Number","Concatenate Cell",null,null,null,"Student ID","Number","Concatenate Cell"]
[null,1612002,74,{"$f":"_xlfn.CONCAT(B5,\",\",C5)","v":"1612002,74"},null,null,null,1612002,74]
[null,1612008,65,{"$f":"_xlfn.CONCAT(B6,\",\",C6)","v":"1612008,65"},null,null,null,1612008,65]
[null,1612014,84,"1612014,84",null,null,null,1612014,84]
[null,1612045,65,"1612045,65",null,null,null,1612045,65]
[null,1612050,59,"1612050,59",null,null,null,1612050,59]
[null,1612055,76,"1612055,76",null,null,null,1612055,76]

{"sheet":"TEXTJOIN Function","index":1,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Applying TEXTJOIN Function",null,null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID","Number","Concatenate Cell",null,null,null,"Student ID","Number","Concatenate Cell"]
[null,1612002,74,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B5:C5)","v":"1612002,74"},null,null,null,1612002,74]
[null,1612008,65,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B6:C6)","v":"1612008,65"},null,null,null,1612008,65]
[null,1612014,84,"1612014,84",null,null,null,1612014,84]
[null,1612045,65,"1612045,65",null,null,null,1612045,65]
[null,1612050,59,"1612050,59",null,null,null,1612050,59]
[null,1612055,76,"1612055,76",null,null,null,1612055,76]

{"sheet":"Concatenate Method","index":2,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using Concatenate Method",null,null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID","Number","Concatenate Cell",null,null,null,"Student ID","Number","Concatenate Cell"]
[null,1612002,74,{"$f":"B5&\",\"&C5","v":"1612002,74"},null,null,null,1612002,74]
[null,1612008,65,"1612008,65",null,null,null,1612008,65]
[null,1612014,84,"1612014,84",null,null,null,1612014,84]
[null,1612045,65,"1612045,65",null,null,null,1612045,65]
[null,1612050,59,"1612050,59",null,null,null,1612050,59]
[null,1612055,76,"1612055,76",null,null,null,1612055,76]

{"sheet":"CONCAT and TRANSPOSE Functions","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[8,1,8,2],[9,1,9,2],[1,6,1,7],[8,6,8,7],[9,6,9,7]]}
[]
[null,"Combining CONCAT and TRANSPOSE Functions",null,null,null,null,"Do it Yourself"]
[]
[null,"Name","William James",null,null,null,"Name","William James"]
[null,"E-mail","wjames.14@gmail.com",null,null,null,"E-mail","wjames.14@gmail.com"]
[null,"City","Texas",null,null,null,"City","Texas"]
[null,"Country","USA",null,null,null,"Country","USA"]
[]
[null,"Concatenate Cell",null,null,null,null,"Concatenate Cell"]
[null,{"$f":"_xlfn.CONCAT(TRANSPOSE(C4:C7)&\",\")","v":"William James,wjames.14@gmail.com,Texas,USA,"}]

{"sheet":"VBA Code","index":4,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4],[6,1,6,4],[7,1,7,4],[1,8,1,11],[6,8,6,11],[7,8,7,11]]}
[]
[null,"Use of VBA Code",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Name","E-mail","City","Country",null,null,null,"Name","E-mail","City","Country"]
[null,"William James","wjames.14@gmail.com","Texas","USA",null,null,null,"William James","wjames.14@gmail.com","Texas","USA"]
[]
[null,"Concatenate Cell",null,null,null,null,null,null,"Concatenate Cell"]
[null,{"$f":"CONCATENATEMULTIPLE(B5:E5,\",\")","v":"William James,wjames.14@gmail.com,Texas,USA"}]