{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset Overview","CONCATENATE","TEXTJOIN","CONCAT","TRANSPOSE","& Operator","Flash Fill","VBA","Practice"],"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 Overview","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset Overview"]
[]
[null,"Employee","Department","Age"]
[null,"Mike","Marketing",25]
[null,"Chris","Accounting",26]
[null,"Paul","Sales",27]
[null,"Andrew","IT",28]

{"sheet":"CONCATENATE","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[9,1,9,4]]}
[]
[null,"Use of CONCATENATE Function"]
[]
[null,"Employee","Department","Age","Helper"]
[null,"Mike","Marketing",25,{"$f":"CONCATENATE(B5,\" \",C5,\" \",D5)","v":"Mike Marketing 25"}]
[null,"Chris","Accounting",26,{"$f":"CONCATENATE(B6,\" \",C6,\" \",D6)","v":"Chris Accounting 26"}]
[null,"Paul","Sales",27,"Paul Sales 27"]
[null,"Andrew","IT",28,"Andrew IT 28"]
[]
[null,{"$f":"CONCATENATE(E5,\",\",E6,\",\",E7,\",\",E8)","v":"Mike Marketing 25,Chris Accounting 26,Paul Sales 27,Andrew IT 28"}]

{"sheet":"TEXTJOIN","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[9,1,9,4]]}
[]
[null,"Use of TEXTJOIN Function"]
[null," "]
[null,"Employee","Department","Age","Helper"]
[null,"Mike","Marketing",25,{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B5:D5)","v":"Mike Marketing 25"}]
[null,"Chris","Accounting",26,{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B6:D6)","v":"Chris Accounting 26"}]
[null,"Paul","Sales",27,"Paul Sales 27"]
[null,"Andrew","IT",28,"Andrew IT 28"]
[]
[null,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,E5:E8)","v":"Mike Marketing 25,Chris Accounting 26,Paul Sales 27,Andrew IT 28"}]

{"sheet":"CONCAT","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[9,1,9,4]]}
[]
[null,"Use of CONCAT Function"]
[null," "]
[null,"Employee","Department","Age","Helper"]
[null,"Mike","Marketing",25,{"$f":"_xlfn.CONCAT(B5,\" \",C5,\" \",D5)","v":"Mike Marketing 25"}]
[null,"Chris","Accounting",26,{"$f":"_xlfn.CONCAT(B6,\" \",C6,\" \",D6)","v":"Chris Accounting 26"}]
[null,"Paul","Sales",27,"Paul Sales 27"]
[null,"Andrew","IT",28,"Andrew IT 28"]
[]
[null,{"$f":"_xlfn.CONCAT(E5,\",\",E6,\",\",E7,\",\",E8)","v":"Mike Marketing 25,Chris Accounting 26,Paul Sales 27,Andrew IT 28"}]

{"sheet":"TRANSPOSE","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of TRANSPOSE Function"]
[null," "]
[null,"Employee","Department","Age"]
[null,"Mike","Marketing",25]
[null,"Chris","Accounting",26]
[null,"Paul","Sales",27]
[null,"Andrew","IT",28]
[]
[null,{"$f":"CONCATENATE(TRANSPOSE(B5:B8&\",\"))","v":"Mike,"},"Chris,","Paul,","Andrew,"]

{"sheet":"& Operator","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[9,1,9,4]]}
[]
[null,"With '&' Operator"]
[null," "]
[null,"Employee","Department","Age","Helper"]
[null,"Mike","Marketing",25,{"$f":"B5&\" \"&C5&\" \"&D5","v":"Mike Marketing 25"}]
[null,"Chris","Accounting",26,{"$f":"B6&\" \"&C6&\" \"&D6","v":"Chris Accounting 26"}]
[null,"Paul","Sales",27,"Paul Sales 27"]
[null,"Andrew","IT",28,"Andrew IT 28"]
[]
[null,{"$f":"E5&\",\"&E6&\",\"&E7&\",\"&E8","v":"Mike Marketing 25,Chris Accounting 26,Paul Sales 27,Andrew IT 28"}]

{"sheet":"Flash Fill","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[9,1,9,4]]}
[]
[null,"Apply Flash Fill"]
[null," "]
[null,"Employee","Department","Age","Helper"]
[null,"Mike","Marketing",25,"Mike Marketing 25"]
[null,"Chris","Accounting",26,"Chris Accounting 26"]
[null,"Paul","Sales",27,"Paul Sales 27"]
[null,"Andrew","IT",28,"Andrew IT 28"]
[]
[null,{"$f":"_xlfn.CONCAT(E5,\",\",E6,\",\",E7,\",\",E8)","v":"Mike Marketing 25,Chris Accounting 26,Paul Sales 27,Andrew IT 28"}]

{"sheet":"VBA","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[9,1,9,4]]}
[]
[null,"With VBA"]
[null," "]
[null,"Employee","Department","Age","Helper"]
[null,"Mike","Marketing",25,{"$f":"_xlfn.CONCAT(B5,\" \",C5,\" \",D5)","v":"Mike Marketing 25"}]
[null,"Chris","Accounting",26,{"$f":"_xlfn.CONCAT(B6,\" \",C6,\" \",D6)","v":"Chris Accounting 26"}]
[null,"Paul","Sales",27,"Paul Sales 27"]
[null,"Andrew","IT",28,"Andrew IT 28"]
[]
[null,{"$f":"Merge(E5:E8)","v":"Mike Marketing 25,Chris Accounting 26,Paul Sales 27,Andrew IT 28"}]

{"sheet":"Practice","index":8,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Try Yourself"]
[null," "]
[null,"Employee","Department","Age"]
[null,"Mike","Marketing",25]
[null,"Chris","Accounting",26]
[null,"Paul","Sales",27]
[null,"Andrew","IT",28]