{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Ampersand","CONCATENATE","CONCAT","TEXTJOIN","Flash Fill","VBA"],"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":"Ampersand","index":0,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,12,1,15],[1,1,1,4]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Company","Product 1","Product 2","Combined",null,null,null,null,null,null,null,"Company","Product 1","Product 2","Combined"]
[null,"A","Mobile","Televison",{"$f":"C5&\", \"&D5","v":"Mobile, Televison"},null,null,null,null,null,null,null,"A","Mobile","Televison"]
[null,"B","Bottle","Blender",{"$f":"C6&\", \"&D6","v":"Bottle, Blender"},null,null,null,null,null,null,null,"B","Bottle","Blender"]
[null,"C","Mouse","Keyboard","Mouse, Keyboard",null,null,null,null,null,null,null,"C","Mouse","Keyboard"]
[null,"D","Headhone","Speaker","Headhone, Speaker",null,null,null,null,null,null,null,"D","Headhone","Speaker"]
[null,"E","Refrigerator","Fan","Refrigerator, Fan",null,null,null,null,null,null,null,"E","Refrigerator","Fan"]
[null,"F","Laptop","Webcams","Laptop, Webcams",null,null,null,null,null,null,null,"F","Laptop","Webcams"]

{"sheet":"CONCATENATE","index":1,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Using CONCATENATE Function",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Company","Product 1","Product 2","Combined",null,null,null,null,null,null,null,"Company","Product 1","Product 2","Combined"]
[null,"A","Mobile","Televison",{"$f":"CONCATENATE(C5,\", \",D5)","v":"Mobile, Televison"},null,null,null,null,null,null,null,"A","Mobile","Televison"]
[null,"B","Bottle","Blender",{"$f":"CONCATENATE(C6,\", \",D6)","v":"Bottle, Blender"},null,null,null,null,null,null,null,"B","Bottle","Blender"]
[null,"C","Mouse","Keyboard","Mouse, Keyboard",null,null,null,null,null,null,null,"C","Mouse","Keyboard"]
[null,"D","Headhone","Speaker","Headhone, Speaker",null,null,null,null,null,null,null,"D","Headhone","Speaker"]
[null,"E","Refrigerator","Fan","Refrigerator, Fan",null,null,null,null,null,null,null,"E","Refrigerator","Fan"]
[null,"F","Laptop","Webcams","Laptop, Webcams",null,null,null,null,null,null,null,"F","Laptop","Webcams"]

{"sheet":"CONCAT","index":2,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Using CONCAT Function",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Company","Product 1","Product 2","Combined",null,null,null,null,null,null,null,"Company","Product 1","Product 2","Combined"]
[null,"A","Mobile","Televison",{"$f":"_xlfn.CONCAT(C5,\",\",D5)","v":"Mobile,Televison"},null,null,null,null,null,null,null,"A","Mobile","Televison",{"$f":"_xlfn.CONCAT(N5,\",\",O5)","v":"Mobile,Televison"}]
[null,"B","Bottle","Blender",{"$f":"_xlfn.CONCAT(C6,\",\",D6)","v":"Bottle,Blender"},null,null,null,null,null,null,null,"B","Bottle","Blender"]
[null,"C","Mouse","Keyboard","Mouse,Keyboard",null,null,null,null,null,null,null,"C","Mouse","Keyboard"]
[null,"D","Headhone","Speaker","Headhone,Speaker",null,null,null,null,null,null,null,"D","Headhone","Speaker"]
[null,"E","Refrigerator","Fan","Refrigerator,Fan",null,null,null,null,null,null,null,"E","Refrigerator","Fan"]
[null,"F","Laptop","Webcams","Laptop,Webcams",null,null,null,null,null,null,null,"F","Laptop","Webcams"]

{"sheet":"TEXTJOIN","index":3,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Using TEXTJOIN Function",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Company","Product 1","Product 2","Combined",null,null,null,null,null,null,null,"Company","Product 1","Product 2","Combined"]
[null,"A","Mobile","Televison",{"$f":"_xlfn.TEXTJOIN(\", \",1,C5,D5)","v":"Mobile, Televison"},null,null,null,null,null,null,null,"A","Mobile","Televison"]
[null,"B","Bottle","Blender",{"$f":"_xlfn.TEXTJOIN(\", \",1,C6,D6)","v":"Bottle, Blender"},null,null,null,null,null,null,null,"B","Bottle","Blender"]
[null,"C","Mouse","Keyboard","Mouse, Keyboard",null,null,null,null,null,null,null,"C","Mouse","Keyboard"]
[null,"D","Headhone","Speaker","Headhone, Speaker",null,null,null,null,null,null,null,"D","Headhone","Speaker"]
[null,"E","Refrigerator","Fan","Refrigerator, Fan",null,null,null,null,null,null,null,"E","Refrigerator","Fan"]
[null,"F","Laptop","Webcams","Laptop, Webcams",null,null,null,null,null,null,null,"F","Laptop","Webcams"]

{"sheet":"Flash Fill","index":4,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Using Flash Fill Feature",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Company","Product 1","Product 2","Combined",null,null,null,null,null,null,null,"Company","Product 1","Product 2","Combined"]
[null,"A","Mobile","Televison","Mobile, Televison",null,null,null,null,null,null,null,"A","Mobile","Televison"]
[null,"B","Bottle","Blender","Bottle, Blender",null,null,null,null,null,null,null,"B","Bottle","Blender"]
[null,"C","Mouse","Keyboard","Mouse, Keyboard",null,null,null,null,null,null,null,"C","Mouse","Keyboard"]
[null,"D","Headhone","Speaker","Headhone, Speaker",null,null,null,null,null,null,null,"D","Headhone","Speaker"]
[null,"E","Refrigerator","Fan","Refrigerator, Fan",null,null,null,null,null,null,null,"E","Refrigerator","Fan"]
[null,"F","Laptop","Webcams","Laptop, Webcams",null,null,null,null,null,null,null,"F","Laptop","Webcams"]

{"sheet":"VBA","index":5,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Using VBA",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Company","Product 1","Product 2","Combined",null,null,null,null,null,null,null,"Company","Product 1","Product 2","Combined"]
[null,"A","Mobile","Televison",{"$f":"Combine(C5:D5,\",\")","v":"Mobile,Televison"},null,null,null,null,null,null,null,"A","Mobile","Televison"]
[null,"B","Bottle","Blender",{"$f":"Combine(C6:D6,\",\")","v":"Bottle,Blender"},null,null,null,null,null,null,null,"B","Bottle","Blender"]
[null,"C","Mouse","Keyboard",{"$f":"Combine(C7:D7,\",\")","v":"Mouse,Keyboard"},null,null,null,null,null,null,null,"C","Mouse","Keyboard"]
[null,"D","Headhone","Speaker",{"$f":"Combine(C8:D8,\",\")","v":"Headhone,Speaker"},null,null,null,null,null,null,null,"D","Headhone","Speaker"]
[null,"E","Refrigerator","Fan",{"$f":"Combine(C9:D9,\",\")","v":"Refrigerator,Fan"},null,null,null,null,null,null,null,"E","Refrigerator","Fan"]
[null,"F","Laptop","Webcams",{"$f":"Combine(C10:D10,\",\")","v":"Laptop,Webcams"},null,null,null,null,null,null,null,"F","Laptop","Webcams"]