{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample Data","Method 1","Method 2","Method 3","Method 4","Method 5","Method 6","Overview"],"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":"Sample Data","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[10,1,12,1],[13,1,15,1],[1,1,1,2],[4,1,6,1],[7,1,9,1]]}
[]
[null,"Sample Dataset"]
[]
[null,"Brand Name","Model Name"]
[null,"Suzuki","Gixxer SF"]
[null,null,"Hayabusa"]
[null,null,"Katana"]
[null,"Yamaha","R15 M"]
[null,null,"FZS Fi v3 ABS"]
[null,null,"MT 15"]
[null,"Honda","X Blade"]
[null,null,"CB 150X"]
[null,null,"Livo Disc Break"]
[null,"Kawasaki","KSR Pro 110"]
[null,null,"Z125"]
[null,null,"Ninja 125"]

{"sheet":"Method 1","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,8,1,9],[4,8,6,8],[7,8,9,8],[10,8,12,8],[13,8,15,8],[10,1,12,1],[13,1,15,1],[1,1,1,2],[4,1,6,1],[7,1,9,1]]}
[]
[null,"Applying Merge & Center Command ",null,null,null,null,null,null,"Practice Worksheet "]
[]
[null,"Brand Name","Model Name",null,null,null,null,null,"Brand Name","Model Name"]
[null,"Suzuki","Gixxer SF",null,null,null,null,null,"Suzuki","Gixxer SF"]
[null,null,"Hayabusa",null,null,null,null,null,null,"Hayabusa"]
[null,null,"Katana",null,null,null,null,null,null,"Katana"]
[null,"Yamaha","R15 M",null,null,null,null,null,"Yamaha","R15 M"]
[null,null,"FZS Fi v3 ABS",null,null,null,null,null,null,"FZS Fi v3 ABS"]
[null,null,"MT 15",null,null,null,null,null,null,"MT 15"]
[null,"Honda","X Blade",null,null,null,null,null,"Honda","X Blade"]
[null,null,"CB 150X",null,null,null,null,null,null,"CB 150X"]
[null,null,"Livo Disc Break",null,null,null,null,null,null,"Livo Disc Break"]
[null,"Kawasaki","KSR Pro 110",null,null,null,null,null,"Kawasaki","KSR Pro 110"]
[null,null,"Z125",null,null,null,null,null,null,"Z125"]
[null,null,"Ninja 125",null,null,null,null,null,null,"Ninja 125"]

{"sheet":"Method 2","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,8,1,9],[4,8,6,8],[7,8,9,8],[10,8,12,8],[13,8,15,8],[1,1,1,2],[10,1,12,1],[13,1,15,1],[4,1,6,1],[7,1,9,1]]}
[]
[null," Utilizing Format Cells Box",null,null,null,null,null,null,"Practice Worksheet "]
[]
[null,"Brand Name","Model Name",null,null,null,null,null,"Brand Name","Model Name"]
[null,"Suzuki","Gixxer SF",null,null,null,null,null,"Suzuki","Gixxer SF"]
[null,null,"Hayabusa",null,null,null,null,null,null,"Hayabusa"]
[null,null,"Katana",null,null,null,null,null,null,"Katana"]
[null,"Yamaha","R15 M",null,null,null,null,null,"Yamaha","R15 M"]
[null,null,"FZS Fi v3 ABS",null,null,null,null,null,null,"FZS Fi v3 ABS"]
[null,null,"MT 15",null,null,null,null,null,null,"MT 15"]
[null,"Honda","X Blade",null,null,null,null,null,"Honda","X Blade"]
[null,null,"CB 150X",null,null,null,null,null,null,"CB 150X"]
[null,null,"Livo Disc Break",null,null,null,null,null,null,"Livo Disc Break"]
[null,"Kawasaki","KSR Pro 110",null,null,null,null,null,"Kawasaki","KSR Pro 110"]
[null,null,"Z125",null,null,null,null,null,null,"Z125"]
[null,null,"Ninja 125",null,null,null,null,null,null,"Ninja 125"]

{"sheet":"Method 3","index":3,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[10,11,12,11],[10,13,12,13],[13,11,15,11],[13,13,15,13],[1,11,1,13],[4,11,6,11],[4,13,6,13],[7,11,9,11],[7,13,9,13],[1,1,1,3],[4,1,6,1],[4,3,6,3],[7,1,9,1],[7,3,9,3],[13,1,15,1],[13,3,15,3],[8,8,8,9],[10,1,12,1],[10,3,12,3]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,null,null,null,null,null,"Practice Worksheet"]
[]
[null,"Brand Name","Model Name","All Models ",null,null,null,null,null,null,null,"Brand Name","Model Name","All Models "]
[null,"Suzuki","Gixxer SF",{"$f":"C5&\", \"&C6&\", \"&C7","v":"Gixxer SF, Hayabusa, Katana"},null,null,null,null,null,null,null,"Suzuki","Gixxer SF"]
[null,null,"Hayabusa",null,null,null,null,null,null,null,null,null,"Hayabusa"]
[null,null,"Katana",null,null,null,null,null,null,null,null,null,"Katana"]
[null,"Yamaha","R15 M",{"$f":"C8&\", \"&C9&\", \"&C10","v":"R15 M, FZS Fi v3 ABS, MT 15"},null,null,null,null,null,null,null,"Yamaha","R15 M"]
[null,null,"FZS Fi v3 ABS",null,null,null,null,null,null,null,null,null,"FZS Fi v3 ABS"]
[null,null,"MT 15",null,null,null,null,null,null,null,null,null,"MT 15"]
[null,"Honda","X Blade",{"$f":"C11&\", \"&C13","v":"X Blade, Livo Disc Break"},null,null,null,null,null,null,null,"Honda","X Blade"]
[null,null,"CB 150X",null,null,null,null,null,null,null,null,null,"CB 150X"]
[null,null,"Livo Disc Break",null,null,null,null,null,null,null,null,null,"Livo Disc Break"]
[null,"Kawasaki","KSR Pro 110",{"$f":"C14&\", \"&C15&\", \"&C16","v":"KSR Pro 110, Z125, Ninja 125"},null,null,null,null,null,null,null,"Kawasaki","KSR Pro 110"]
[null,null,"Z125",null,null,null,null,null,null,null,null,null,"Z125"]
[null,null,"Ninja 125",null,null,null,null,null,null,null,null,null,"Ninja 125"]

{"sheet":"Method 4","index":4,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[10,12,12,12],[10,14,12,14],[13,12,15,12],[13,14,15,14],[1,12,1,14],[4,12,6,12],[4,14,6,14],[7,12,9,12],[7,14,9,14],[13,1,15,1],[13,3,15,3],[8,8,8,10],[1,1,1,3],[4,1,6,1],[4,3,6,3],[7,1,9,1],[7,3,9,3],[10,1,12,1],[10,3,12,3]]}
[]
[null,"Applying CONCATENATE Function",null,null,null,null,null,null,null,null,null,null,"Practice Worksheet"]
[]
[null,"Brand Name","Model Name","All Models ",null,null,null,null,null,null,null,null,"Brand Name","Model Name","All Models "]
[null,"Suzuki","Gixxer SF",{"$f":"CONCATENATE(C5,\", \",C6,\", \",C7)","v":"Gixxer SF, Hayabusa, Katana"},null,null,null,null,null,null,null,null,"Suzuki","Gixxer SF"]
[null,null,"Hayabusa",null,null,null,null,null,null,null,null,null,null,"Hayabusa"]
[null,null,"Katana",null,null,null,null,null,null,null,null,null,null,"Katana"]
[null,"Yamaha","R15 M",{"$f":"CONCATENATE(C8,\", \",C9,\", \",C10)","v":"R15 M, FZS Fi v3 ABS, MT 15"},null,null,null,null,null,null,null,null,"Yamaha","R15 M"]
[null,null,"FZS Fi v3 ABS",null,null,null,null,null,null,null,null,null,null,"FZS Fi v3 ABS"]
[null,null,"MT 15",null,null,null,null,null,null,null,null,null,null,"MT 15"]
[null,"Honda","X Blade",{"$f":"CONCATENATE(C11,\", \",C12,\", \",C13)","v":"X Blade, CB 150X, Livo Disc Break"},null,null,null,null,null,null,null,null,"Honda","X Blade"]
[null,null,"CB 150X",null,null,null,null,null,null,null,null,null,null,"CB 150X"]
[null,null,"Livo Disc Break",null,null,null,null,null,null,null,null,null,null,"Livo Disc Break"]
[null,"Kawasaki","KSR Pro 110",{"$f":"CONCATENATE(C14,\", \",C15,\", \",C16)","v":"KSR Pro 110, Z125, Ninja 125"},null,null,null,null,null,null,null,null,"Kawasaki","KSR Pro 110"]
[null,null,"Z125",null,null,null,null,null,null,null,null,null,null,"Z125"]
[null,null,"Ninja 125",null,null,null,null,null,null,null,null,null,null,"Ninja 125"]

{"sheet":"Method 5","index":5,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[10,11,12,11],[10,13,12,13],[13,11,15,11],[13,13,15,13],[1,11,1,13],[4,11,6,11],[4,13,6,13],[7,11,9,11],[7,13,9,13],[13,1,15,1],[13,3,15,3],[9,8,9,10],[1,1,1,3],[4,1,6,1],[4,3,6,3],[7,1,9,1],[7,3,9,3],[10,1,12,1],[10,3,12,3]]}
[]
[null,"Using TEXTJOIN Function",null,null,null,null,null,null,null,null,null,"Practice Worksheet"]
[]
[null,"Brand Name","Model Name","All Models ",null,null,null,null,null,null,null,"Brand Name","Model Name","All Models "]
[null,"Suzuki","Gixxer SF",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,C5,C6,C7)","v":"Gixxer SF,Hayabusa,Katana"},null,null,null,null,null,null,null,"Suzuki","Gixxer SF"]
[null,null,"Hayabusa",null,null,null,null,null,null,null,null,null,"Hayabusa"]
[null,null,"Katana",null,null,null,null,null,null,null,null,null,"Katana"]
[null,"Yamaha","R15 M",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,C8,C9,C10)","v":"R15 M,FZS Fi v3 ABS,MT 15"},null,null,null,null,null,null,null,"Yamaha","R15 M"]
[null,null,"FZS Fi v3 ABS",null,null,null,null,null,null,null,null,null,"FZS Fi v3 ABS"]
[null,null,"MT 15",null,null,null,null,null,null,null,null,null,"MT 15"]
[null,"Honda","X Blade",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,C11,C12,C13)","v":"X Blade,CB 150X,Livo Disc Break"},null,null,null,null,null,null,null,"Honda","X Blade"]
[null,null,"CB 150X",null,null,null,null,null,null,null,null,null,"CB 150X"]
[null,null,"Livo Disc Break",null,null,null,null,null,null,null,null,null,"Livo Disc Break"]
[null,"Kawasaki","KSR Pro 110",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,C14,C15,C16)","v":"KSR Pro 110,Z125,Ninja 125"},null,null,null,null,null,null,null,"Kawasaki","KSR Pro 110"]
[null,null,"Z125",null,null,null,null,null,null,null,null,null,"Z125"]
[null,null,"Ninja 125",null,null,null,null,null,null,null,null,null,"Ninja 125"]

{"sheet":"Method 6","index":6,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,1,6,1],[7,1,9,1],[10,1,12,1],[13,1,15,1],[4,2,6,2],[7,2,9,2],[10,2,12,2],[13,2,15,2],[13,7,15,7],[1,7,1,8],[4,7,6,7],[7,7,9,7],[10,7,12,7]]}
[]
[null,"Implying VBA Code",null,null,null,null,null,"Try Yourself"]
[]
[null,"Brand Name","Model Name",null,null,null,null,"Brand Name","Model Name"]
[null,"Suzuki","Gixxer SF\r\nHayabusa\r\nKatana",null,null,null,null,"Suzuki","Gixxer SF"]
[null,null,null,null,null,null,null,null,"Hayabusa"]
[null,null,null,null,null,null,null,null,"Katana"]
[null,"Yamaha","R15 M\r\nFZS Fi v3 ABS\r\nMT 15",null,null,null,null,"Yamaha","R15 M"]
[null,null,null,null,null,null,null,null,"FZS Fi v3 ABS"]
[null,null,null,null,null,null,null,null,"MT 15"]
[null,"Honda","X Blade\r\nCB 150X\r\nLivo Disc Break",null,null,null,null,"Honda","X Blade"]
[null,null,null,null,null,null,null,null,"CB 150X"]
[null,null,null,null,null,null,null,null,"Livo Disc Break"]
[null,"Kawasaki","KSR Pro 110\r\nZ125\r\nNinja 125",null,null,null,null,"Kawasaki","KSR Pro 110"]
[null,null,null,null,null,null,null,null,"Z125"]
[null,null,null,null,null,null,null,null,"Ninja 125"]

{"sheet":"Overview","index":7,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,6,15,8],[13,1,15,1],[13,3,15,3],[5,5,5,8],[6,6,6,8],[7,6,7,8],[9,5,9,8],[10,6,10,8],[11,6,11,8],[13,5,13,8],[14,6,14,8],[1,1,1,3],[4,1,6,1],[4,3,6,3],[7,1,9,1],[7,3,9,3],[10,1,12,1],[10,3,12,3]]}
[]
[null,"Overview of Merging Vertical Cells"]
[]
[null,"Brand Name","Model Name","All Models "]
[null,"Suzuki","Gixxer SF",{"$f":"C5&\", \"&C6&\", \"&C7","v":"Gixxer SF, Hayabusa, Katana"}]
[null,null,"Hayabusa",null,null,"Method 3:Using Ampersand Operator"]
[null,null,"Katana",null,null,"Formula ","C5&\", \"&C6&\", \"&C7"]
[null,"Yamaha","R15 M",{"$f":"C8&\", \"&C9&\", \"&C10","v":"R15 M, FZS Fi v3 ABS, MT 15"},null,"Result",{"$f":"C5&\",\"&C6&\",\"&C7","v":"Gixxer SF,Hayabusa,Katana"}]
[null,null,"FZS Fi v3 ABS"]
[null,null,"MT 15",null,null,"Method 4:Applying CONCATENATE Function"]
[null,"Honda","X Blade",{"$f":"C11&\", \"&C13","v":"X Blade, Livo Disc Break"},null,"Formula ","CONCATENATE(C5,\", \",C6,\", \",C7)"]
[null,null,"CB 150X",null,null,"Result",{"$f":"C5&\",\"&C6&\",\"&C7","v":"Gixxer SF,Hayabusa,Katana"}]
[null,null,"Livo Disc Break"]
[null,"Kawasaki","KSR Pro 110",{"$f":"C14&\", \"&C15&\", \"&C16","v":"KSR Pro 110, Z125, Ninja 125"},null,"Method 5 :Using TEXTJOIN Function"]
[null,null,"Z125",null,null,"Formula ","TEXTJOIN(\",\",TRUE,C5,C6,C7)"]
[null,null,"Ninja 125",null,null,"Result",{"$f":"C13&\",\"&C14&\",\"&C15","v":"Livo Disc Break,KSR Pro 110,Z125"}]