{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Product Record","CONCATENATE & TRANSPOSE","TEXTJOIN","VBA","Power Query","Fill Justify"],"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":"Product Record","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Product Record of Mars Group"]
[]
[null,"Product ID","Product Name"]
[null,231,"Desktop"]
[null,101,"Laptop"]
[null,146,"Smartphone"]
[null,192,"Television"]
[null,179,"Radio"]

{"sheet":"CONCATENATE & TRANSPOSE","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[10,1,10,2],[11,1,11,2],[1,6,1,7],[10,6,10,7],[11,6,11,7]]}
[]
[null,"Combinining CONCATENATE & TRANSPOSE Functions",null,null,null,null,"Try Yourself"]
[]
[null,"Product ID","Product Name",null,null,null,"Product ID","Product Name"]
[null,231,"Desktop",null,null,null,231,"Desktop"]
[null,101,"Laptop",null,null,null,101,"Laptop"]
[null,146,"Smartphone",null,null,null,146,"Smartphone"]
[null,192,"Television",null,null,null,192,"Television"]
[null,179,"Radio",null,null,null,179,"Radio"]
[]
[null,"List of Products",null,null,null,null,"List of Products"]
[null,{"$f":"CONCATENATE(\"Desktop,\",\"Laptop,\",\"Smartphone,\",\"Television,\",\"Radio,\")","v":"Desktop,Laptop,Smartphone,Television,Radio,"}]

{"sheet":"TEXTJOIN","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[10,1,10,2],[11,1,11,2],[1,6,1,7],[10,6,10,7],[11,6,11,7]]}
[]
[null,"Using TEXTJOIN Function",null,null,null,null,"Try Yourself"]
[]
[null,"Product ID","Product Name",null,null,null,"Product ID","Product Name"]
[null,231,"Desktop",null,null,null,231,"Desktop"]
[null,101,"Laptop",null,null,null,101,"Laptop"]
[null,146,"Smartphone",null,null,null,146,"Smartphone"]
[null,192,"Television",null,null,null,192,"Television"]
[null,179,"Radio",null,null,null,179,"Radio"]
[]
[null,"List of Products",null,null,null,null,"List of Products"]
[null,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,C5:C9)","v":"Desktop,Laptop,Smartphone,Television,Radio"}]

{"sheet":"VBA","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[10,1,10,2],[11,1,11,2],[1,6,1,7],[10,6,10,7],[11,6,11,7]]}
[]
[null,"Applying VBA",null,null,null,null,"Try Yourself"]
[]
[null,"Product ID","Product Name",null,null,null,"Product ID","Product Name"]
[null,231,"Desktop",null,null,null,231,"Desktop"]
[null,101,"Laptop",null,null,null,101,"Laptop"]
[null,146,"Smartphone",null,null,null,146,"Smartphone"]
[null,192,"Television",null,null,null,192,"Television"]
[null,179,"Radio",null,null,null,179,"Radio"]
[]
[null,"List of Products",null,null,null,null,"List of Products"]
[null,{"$f":"TEXTJOIN2(\", \",TRUE,C5:C9)","v":"Desktop, Laptop, Smartphone, Television, Radio"}]

{"sheet":"Power Query","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Power Query"]
[]
[null,"Product ID","Product Name"]
[null,231,"Desktop"]
[null,101,"Laptop"]
[null,146,"Smartphone"]
[null,192,"Television"]
[null,179,"Radio"]

{"sheet":"Fill Justify","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Fill Justify Command"]
[]
[null,"Product ID","Product Name"]
[null,231,"Desktop, Laptop, Smartphone, Television, Radio"]
[null,101]
[null,146]
[null,192]
[null,179]