{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","comma","Concate","Concate+Transpose","Textjoin","VBA","Space","Formula Together"],"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":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Officials of ALPHA Ltd."]
[]
[null,"Designation","Name","Region"]
[null,"Sales Manager","Jenny","Texas"]
[null,"Deputy Manager","Mike","Florida"]
[null,"Assistant Manager","Ammy","Louisiana"]
[null,"Deputy Manager","Steve","Georgia"]
[]
[]
[null,"Total"]

{"sheet":"comma","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Officials of ALPHA Ltd."]
[]
[null,"Designation","Name","Region","Concatenation"]
[null,"Sales Manager","Jenny","Texas",{"$f":"B6&\", \"&C6&\", \"&D6","v":"Sales Manager, Jenny, Texas"}]
[null,"Deputy Manager","Mike","Florida",{"$f":"B7&\", \"&C7&\", \"&D7","v":"Deputy Manager, Mike, Florida"}]
[null,"Assistant Manager","Ammy","Louisiana","Assistant Manager, Ammy, Louisiana"]
[null,"Deputy Manager","Steve","Georgia","Deputy Manager, Steve, Georgia"]
[]
[]
[null,"Total"]

{"sheet":"Concate","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Officials of ALPHA Ltd."]
[]
[null,"Designation","Name","Region","Concatenation"]
[null,"Sales Manager","Jenny","Texas",{"$f":"CONCATENATE(B6,\", \",C6,\", \",D6)","v":"Sales Manager, Jenny, Texas"}]
[null,"Deputy Manager","Mike","Florida",{"$f":"CONCATENATE(B7,\", \",C7,\", \",D7)","v":"Deputy Manager, Mike, Florida"}]
[null,"Assistant Manager","Ammy","Louisiana","Assistant Manager, Ammy, Louisiana"]
[null,"Deputy Manager","Steve","Georgia","Deputy Manager, Steve, Georgia"]
[]
[]
[null,"Total"]

{"sheet":"Concate+Transpose","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Officials of ALPHA Ltd."]
[]
[null,"Designation","Sales Manager","Deputy Manager","Assistant Manager","Deputy Manager"]
[null,"Name","Jenny","Mike","Ammy","Steve"]
[null,"Region","Texas","Florida","Louisiana","Georgia"]
[]
[null,"Concatenation",{"$f":"CONCATENATE(\"Sales Manager, \", \"Jenny, \", \"Texas,\")","v":"Sales Manager, Jenny, Texas,"},{"$f":"CONCATENATE(\"Sales Manager, \", \"Jenny, \", \"Texas,\")","v":"Sales Manager, Jenny, Texas,"},"Sales Manager, Jenny, Texas,","Sales Manager, Jenny, Texas,"]
[null,"Total"]

{"sheet":"Textjoin","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Officials of ALPHA Ltd."]
[]
[null,"Designation","Name","Region","Concatenation"]
[null,"Sales Manager","Jenny","Texas",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B6:D6)","v":"Sales Manager,Jenny,Texas"}]
[null,"Deputy Manager","Mike","Florida",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B7:D7)","v":"Deputy Manager,Mike,Florida"}]
[null,"Assistant Manager","Ammy","Louisiana","Assistant Manager,Ammy,Louisiana"]
[null,"Deputy Manager","Steve","Georgia","Deputy Manager,Steve,Georgia"]
[]
[]
[null,"Total"]

{"sheet":"VBA","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Officials of ALPHA Ltd."]
[]
[null,"Designation","Name","Region"]
[null,"Sales Manager","Jenny","Texas","Sales Manager, Jenny,Texas"]
[null,"Deputy Manager","Mike","Florida","Deputy Manager, Mike,Florida"]
[null,"Assistant Manager","Ammy","Louisiana","Assistant Manager, Ammy,Louisiana"]
[null,"Deputy Manager","Steve","Georgia","Deputy Manager, Steve,Georgia"]
[]
[]
[null,"Total"]

{"sheet":"Space","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Officials of ALPHA Ltd."]
[]
[null,"Designation","Name","Region","Concatenation"]
[null,"Sales Manager","Jenny","Texas","Sales Manager Jenny Texas"]
[null,"Deputy Manager","Mike","Florida","Deputy Manager Mike Florida"]
[null,"Assistant Manager","Ammy","Louisiana","Assistant Manager Ammy Louisiana"]
[null,"Deputy Manager","Steve","Georgia","Deputy Manager Steve Georgia"]
[]
[]
[null,"Total"]

{"sheet":"Formula Together","index":7,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Officials of ALPHA Ltd."]
[]
[null,"Designation","Name","Region","Formula","Concatenation"]
[null,"Sales Manager","Jenny","Texas",{"$f":"B6&\", \"&C6&\", \"&D6","v":"Sales Manager, Jenny, Texas"},"Sales Manager, Jenny, Texas"]
[null,"Deputy Manager","Mike","Florida",{"$f":"CONCATENATE(B7,\", \",C7,\", \",D7)","v":"Deputy Manager, Mike, Florida"},"Deputy Manager, Mike, Florida"]
[null,"Assistant Manager","Ammy","Louisiana",{"$f":"CONCATENATE(TRANSPOSE(C6:C9)&\",\")","v":{"$error":"#VALUE!"}},"Jenny, Mike, Ammy, Steve"]
[null,"Deputy Manager","Steve","Georgia",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B9:D9)","v":"Deputy Manager,Steve,Georgia"},"Deputy Manager,Steve,Georgia"]
[]
[]
[null,"Total"]