{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Concatenating Rows","Joining Columns","Concatenating Rows & Columns","Employing User Defined Function"],"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":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Product Name","Sales (2019)","Sales (2020)"]
[null,"Desktop",287,391]
[null,"Laptop",303,217]
[null,"Smartphone",632,776]
[null,"Landphone",198,101]
[null,"Telephone",693,359]
[null,"Refrigerator",476,598]
[null,"Television",772,212]

{"sheet":"Concatenating Rows","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Concatenating Rows",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product Name","Sales (2019)","Sales (2020)","Concatenated Values"," ",null,null,null,null,null,"Product Name","Sales (2019)","Sales (2020)","Concatenated Values"]
[null,"Desktop",287,391," 287, 391",null,null,null,null,null,null,"Desktop",287,391]
[null,"Laptop",303,217," 303, 217",null,null,null,null,null,null,"Laptop",303,217]
[null,"Smartphone",632,776," 632, 776",null,null,null,null,null,null,"Smartphone",632,776]
[null,"Landphone",198,101," 198, 101",null,null,null,null,null,null,"Landphone",198,101]
[null,"Telephone",693,359," 693, 359",null,null,null,null,null,null,"Telephone",693,359]
[null,"Refrigerator",476,598," 476, 598",null,null,null,null,null,null,"Refrigerator",476,598]
[null,"Television",772,212," 772, 212",null,null,null,null,null,null,"Television",772,212]

{"sheet":"Joining Columns","index":2,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Joining Columns",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product Name","Sales (2019)","Sales (2020)","Concatenated Values"," ",null,null,null,null,"Product Name","Sales (2019)","Sales (2020)","Concatenated Values"]
[null,"Desktop",287,391," 287- 303- 632- 198- 693- 476- 772",null,null,null,null,null,"Desktop",287,391]
[null,"Laptop",303,217," 391- 217- 776- 101- 359- 598- 212",null,null,null,null,null,"Laptop",303,217]
[null,"Smartphone",632,776,null,null,null,null,null," ","Smartphone",632,776]
[null,"Landphone",198,101,null,null,null,null,null,null,"Landphone",198,101]
[null,"Telephone",693,359,null,null,null,null,null,null,"Telephone",693,359]
[null,"Refrigerator",476,598,null,null,null,null,null,null,"Refrigerator",476,598]
[null,"Television",772,212,null,null,null,null,null,null,"Television",772,212]

{"sheet":"Concatenating Rows & Columns","index":3,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[12,2,12,3],[1,9,1,11],[12,10,12,11]]}
[]
[null,"Concatenating Range Considering Both Rows and Columns",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product Name","Sales (2019)","Sales (2020)"," ",null,null,null,null,"Product Name","Sales (2019)","Sales (2020)"]
[null,"Desktop",287,391,null,null,null,null,null,"Desktop",287,391]
[null,"Laptop",303,217,null,null,null,null,null,"Laptop",303,217]
[null,"Smartphone",632,776,null,null,null,null," ","Smartphone",632,776]
[null,"Landphone",198,101,null,null,null,null,null,"Landphone",198,101]
[null,"Telephone",693,359,null,null,null,null,null,"Telephone",693,359]
[null,"Refrigerator",476,598,null,null,null,null,null,"Refrigerator",476,598]
[null,"Television",772,212,null,null,null,null,null,"Television",772,212]
[]
[null,"Concatenated Values"," 287, 391, 303, 217, 632, 776",null,null,null,null,null,null,"Concatenated Values"]

{"sheet":"Employing User Defined Function","index":4,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Employing User Defined Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product Name","Sales (2019)","Sales (2020)","Concatenated Values"," ",null,null,null,null,"Product Name","Sales (2019)","Sales (2020)","Concatenated Values"]
[null,"Desktop",287,391,{"$f":"ConcatenateSales(C5:C11,\",\")","v":"287,303,632,198,693,476,772"},null,null,null,null,null,"Desktop",287,391]
[null,"Laptop",303,217,{"$f":"ConcatenateSales(D5:D11,\",\")","v":"391,217,776,101,359,598,212"},null,null,null,null,null,"Laptop",303,217]
[null,"Smartphone",632,776,null,null,null,null,null," ","Smartphone",632,776]
[null,"Landphone",198,101,null,null,null,null,null,null,"Landphone",198,101]
[null,"Telephone",693,359,null,null,null,null,null,null,"Telephone",693,359]
[null,"Refrigerator",476,598,null,null,null,null,null,null,"Refrigerator",476,598]
[null,"Television",772,212,null,null,null,null,null,null,"Television",772,212]