{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","Merge and Center","Merge Cells","Format Cells Feature","CONCATENATE Function","CONCAT Function","Ampersand Symbol","TEXTJOIN Function","Clipboard","CONCATENATE and TRANSPOSE ","Notepad","Excel 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":"Dataset","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Rows in Excel"]
[]
[null,"Sl. No","Book","Author"]
[null,1,"The Silent Patient","Alex Michaelides"]
[null,2,"The Maidens","Alex Michaelides"]
[null,3,"3:00 A.M.","Nick Pirog"]
[null,4,"3:21 A.M.","Nick Pirog"]
[null,5,"3:46 A.M.","Nick Pirog"]
[null,6,"Deadly Cross","James Patterson"]
[null,7,"The President Is Missing","James Patterson"]
[null,8,"The Summer House","James Patterson"]
[null,9,"Detective Cross","James Patterson"]

{"sheet":"Merge and Center","index":1,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,5,3],[6,3,8,3],[9,3,12,3],[1,9,1,11]]}
[]
[null,"Using Merge & Center Option",null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Sl. No","Book","Author",null,null,null,null,null,"Sl. No","Book","Author"]
[null,1,"The Silent Patient","Alex Michaelides",null,null,null,null,null,1,"The Silent Patient","Alex Michaelides"]
[null,2,"The Maidens",null,null,null,null,null,null,2,"The Maidens","Alex Michaelides"]
[null,3,"3:00 A.M.","Nick Pirog",null,null,null,null,null,3,"3:00 A.M.","Nick Pirog"]
[null,4,"3:21 A.M.",null,null,null,null,null,null,4,"3:21 A.M.","Nick Pirog"]
[null,5,"3:46 A.M.",null,null,null,null,null,null,5,"3:46 A.M.","Nick Pirog"]
[null,6,"Deadly Cross","James Patterson",null,null,null,null,null,6,"Deadly Cross","James Patterson"]
[null,7,"The President Is Missing",null,null,null,null,null,null,7,"The President Is Missing","James Patterson"]
[null,8,"The Summer House",null,null,null,null,null,null,8,"The Summer House","James Patterson"]
[null,9,"Detective Cross",null,null,null,null,null,null,9,"Detective Cross","James Patterson"]

{"sheet":"Merge Cells","index":2,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,5,3],[6,3,8,3],[9,3,12,3],[1,8,1,10]]}
[]
[null,"Employing Merge Cells Option",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Sl. No","Book","Author",null,null,null,null,"Sl. No","Book","Author"]
[null,1,"The Silent Patient","Alex Michaelides",null,null,null,null,1,"The Silent Patient","Alex Michaelides"]
[null,2,"The Maidens",null,null,null,null,null,2,"The Maidens","Alex Michaelides"]
[null,3,"3:00 A.M.","Nick Pirog",null,null,null,null,3,"3:00 A.M.","Nick Pirog"]
[null,4,"3:21 A.M.",null,null,null,null,null,4,"3:21 A.M.","Nick Pirog"]
[null,5,"3:46 A.M.",null,null,null,null,null,5,"3:46 A.M.","Nick Pirog"]
[null,6,"Deadly Cross","James Patterson",null,null,null,null,6,"Deadly Cross","James Patterson"]
[null,7,"The President Is Missing",null,null,null,null,null,7,"The President Is Missing","James Patterson"]
[null,8,"The Summer House",null,null,null,null,null,8,"The Summer House","James Patterson"]
[null,9,"Detective Cross",null,null,null,null,null,9,"Detective Cross","James Patterson"]

{"sheet":"Format Cells Feature","index":3,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,9,1,11],[1,1,1,3],[4,3,5,3],[6,3,8,3],[9,3,12,3]]}
[]
[null,"Using Format Cells Feature",null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Sl. No","Book","Author",null,null,null,null,null,"Sl. No","Book","Author"]
[null,1,"The Silent Patient","Alex Michaelides",null,null,null,null,null,1,"The Silent Patient","Alex Michaelides"]
[null,2,"The Maidens",null,null,null,null,null,null,2,"The Maidens","Alex Michaelides"]
[null,3,"3:00 A.M.","Nick Pirog",null,null,null,null,null,3,"3:00 A.M.","Nick Pirog"]
[null,4,"3:21 A.M.",null,null,null,null,null,null,4,"3:21 A.M.","Nick Pirog"]
[null,5,"3:46 A.M.",null,null,null,null,null,null,5,"3:46 A.M.","Nick Pirog"]
[null,6,"Deadly Cross","James Patterson",null,null,null,null,null,6,"Deadly Cross","James Patterson"]
[null,7,"The President Is Missing",null,null,null,null,null,null,7,"The President Is Missing","James Patterson"]
[null,8,"The Summer House",null,null,null,null,null,null,8,"The Summer House","James Patterson"]
[null,9,"Detective Cross",null,null,null,null,null,null,9,"Detective Cross","James Patterson"]

{"sheet":"CONCATENATE Function","index":4,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of CONCATENATE Function",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Sl. No","Book","Author",null,null,null,null,"Sl. No","Book","Author"]
[null,1,"The Silent Patient","Alex Michaelides",null,null,null,null,1,"The Silent Patient","Alex Michaelides"]
[null,2,"The Maidens","Alex Michaelides",null,null,null,null,2,"The Maidens","Alex Michaelides"]
[null,3,"3:00 A.M.","Nick Pirog",null,null,null,null,3,"3:00 A.M.","Nick Pirog"]
[null,4,"3:21 A.M.","Nick Pirog",null,null,null,null,4,"3:21 A.M.","Nick Pirog"]
[null,5,"3:46 A.M.","Nick Pirog",null,null,null,null,5,"3:46 A.M.","Nick Pirog"]
[null,6,"Deadly Cross","James Patterson",null,null,null,null,6,"Deadly Cross","James Patterson"]
[null,7,"The President Is Missing","James Patterson",null,null,null,null,7,"The President Is Missing","James Patterson"]
[null,8,"The Summer House","James Patterson",null,null,null,null,8,"The Summer House","James Patterson"]
[null,9,"Detective Cross","James Patterson",null,null,null,null,9,"Detective Cross","James Patterson"]
[]
[null,"Author","Book",null,null,null,null,null,"Author","Book"]
[null,"Alex Michaelides",{"$f":"CONCATENATE(C5, \", \",C6)","v":"The Silent Patient, The Maidens"},null,null,null,null,null,"Alex Michaelides"]

{"sheet":"CONCAT Function","index":5,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of CONCAT Function",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Sl. No","Book","Author",null,null,null,null,"Sl. No","Book","Author"]
[null,1,"The Silent Patient","Alex Michaelides",null,null,null,null,1,"The Silent Patient","Alex Michaelides"]
[null,2,"The Maidens","Alex Michaelides",null,null,null,null,2,"The Maidens","Alex Michaelides"]
[null,3,"3:00 A.M.","Nick Pirog",null,null,null,null,3,"3:00 A.M.","Nick Pirog"]
[null,4,"3:21 A.M.","Nick Pirog",null,null,null,null,4,"3:21 A.M.","Nick Pirog"]
[null,5,"3:46 A.M.","Nick Pirog",null,null,null,null,5,"3:46 A.M.","Nick Pirog"]
[null,6,"Deadly Cross","James Patterson",null,null,null,null,6,"Deadly Cross","James Patterson"]
[null,7,"The President Is Missing","James Patterson",null,null,null,null,7,"The President Is Missing","James Patterson"]
[null,8,"The Summer House","James Patterson",null,null,null,null,8,"The Summer House","James Patterson"]
[null,9,"Detective Cross","James Patterson",null,null,null,null,9,"Detective Cross","James Patterson"]
[]
[null,"Author","Book",null,null,null,null,null,"Author","Book"]
[null,"Nick Pirog",{"$f":"_xlfn.CONCAT(C7,\", \",C8,\", \",C9)","v":"3:00 A.M., 3:21 A.M., 3:46 A.M."},null,null,null,null,null,"Nick Pirog"]

{"sheet":"Ampersand Symbol","index":6,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of Ampersand Symbol",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Sl. No","Book","Author",null,null,null,null,"Sl. No","Book","Author"]
[null,1,"The Silent Patient","Alex Michaelides",null,null,null,null,1,"The Silent Patient","Alex Michaelides"]
[null,2,"The Maidens","Alex Michaelides",null,null,null,null,2,"The Maidens","Alex Michaelides"]
[null,3,"3:00 A.M.","Nick Pirog",null,null,null,null,3,"3:00 A.M.","Nick Pirog"]
[null,4,"3:21 A.M.","Nick Pirog",null,null,null,null,4,"3:21 A.M.","Nick Pirog"]
[null,5,"3:46 A.M.","Nick Pirog",null,null,null,null,5,"3:46 A.M.","Nick Pirog"]
[null,6,"Deadly Cross","James Patterson",null,null,null,null,6,"Deadly Cross","James Patterson"]
[null,7,"The President Is Missing","James Patterson",null,null,null,null,7,"The President Is Missing","James Patterson"]
[null,8,"The Summer House","James Patterson",null,null,null,null,8,"The Summer House","James Patterson"]
[null,9,"Detective Cross","James Patterson",null,null,null,null,9,"Detective Cross","James Patterson"]
[]
[null,"Author","Book",null,null,null,null,null,"Author","Book"]
[null,"Alex Michaelides",{"$f":"C5 & \", \" & C6","v":"The Silent Patient, The Maidens"},null,null,null,null,null,"Alex Michaelides"]

{"sheet":"TEXTJOIN Function","index":7,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of Ampersand Symbol",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Sl. No","Book","Author",null,null,null,null,"Sl. No","Book","Author"]
[null,1,"The Silent Patient","Alex Michaelides",null,null,null,null,1,"The Silent Patient","Alex Michaelides"]
[null,2,"The Maidens","Alex Michaelides",null,null,null,null,2,"The Maidens","Alex Michaelides"]
[null,3,"3:00 A.M.","Nick Pirog",null,null,null,null,3,"3:00 A.M.","Nick Pirog"]
[null,4,"3:21 A.M.","Nick Pirog",null,null,null,null,4,"3:21 A.M.","Nick Pirog"]
[null,5,"3:46 A.M.","Nick Pirog",null,null,null,null,5,"3:46 A.M.","Nick Pirog"]
[null,6,"Deadly Cross","James Patterson",null,null,null,null,6,"Deadly Cross","James Patterson"]
[null,7,"The President Is Missing","James Patterson",null,null,null,null,7,"The President Is Missing","James Patterson"]
[null,8,"The Summer House","James Patterson",null,null,null,null,8,"The Summer House","James Patterson"]
[null,9,"Detective Cross","James Patterson",null,null,null,null,9,"Detective Cross","James Patterson"]
[]
[null,"Author","Book",null,null,null,null,null,"Author","Book"]
[null,"Nick Pirog",{"$f":"_xlfn.TEXTJOIN(\", \", FALSE, C7, C8, C9)","v":"3:00 A.M., 3:21 A.M., 3:46 A.M."},null,null,null,null,null,"Nick Pirog"]

{"sheet":"Clipboard","index":8,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,7,1,9],[1,1,1,3]]}
[]
[null,"Using Clipboard",null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Sl. No","Book","Author",null,null,null,"Sl. No","Book","Author"]
[null,1,"The Silent Patient","Alex Michaelides",null,null,null,1,"The Silent Patient","Alex Michaelides"]
[null,2,"The Maidens","Alex Michaelides",null,null,null,2,"The Maidens","Alex Michaelides"]
[null,3,"3:00 A.M.","Nick Pirog",null,null,null,3,"3:00 A.M.","Nick Pirog"]
[null,4,"3:21 A.M.","Nick Pirog",null,null,null,4,"3:21 A.M.","Nick Pirog"]
[null,5,"3:46 A.M.","Nick Pirog",null,null,null,5,"3:46 A.M.","Nick Pirog"]
[null,6,"Deadly Cross","James Patterson",null,null,null,6,"Deadly Cross","James Patterson"]
[null,7,"The President Is Missing","James Patterson",null,null,null,7,"The President Is Missing","James Patterson"]
[null,8,"The Summer House","James Patterson",null,null,null,8,"The Summer House","James Patterson"]
[null,9,"Detective Cross","James Patterson",null,null,null,9,"Detective Cross","James Patterson"]
[]
[null,"Author","Book",null,null,null,null,"Author","Book"]
[null,"Alex Michaelides","The Silent Patient\nThe Maidens",null,null,null,null,"Alex Michaelides"]

{"sheet":"CONCATENATE and TRANSPOSE ","index":9,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,5,3],[6,3,8,3],[9,3,12,3],[1,9,1,11],[4,11,5,11],[6,11,8,11],[9,11,12,11]]}
[]
[null,"Applying CONCATENATE & TRANSPOSE Functions",null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Sl. No","Book","Author",null,null,null,null,null,"Sl. No","Book","Author"]
[null,1,"The Silent Patient","Alex Michaelides",null,null,null,null,null,1,"The Silent Patient","Alex Michaelides"]
[null,2,"The Maidens",null,null,null,null,null,null,2,"The Maidens"]
[null,3,"3:00 A.M.","Nick Pirog",null,null,null,null,null,3,"3:00 A.M.","Nick Pirog"]
[null,4,"3:21 A.M.",null,null,null,null,null,null,4,"3:21 A.M."]
[null,5,"3:46 A.M.",null,null,null,null,null,null,5,"3:46 A.M."]
[null,6,"Deadly Cross","James Patterson",null,null,null,null,null,6,"Deadly Cross","James Patterson"]
[null,7,"The President Is Missing",null,null,null,null,null,null,7,"The President Is Missing"]
[null,8,"The Summer House",null,null,null,null,null,null,8,"The Summer House"]
[null,9,"Detective Cross",null,null,null,null,null,null,9,"Detective Cross"]
[]
[null,"Author","Book",null,null,null,null,null,null,"Author","Book"]
[null,{"$f":"CONCATENATE(TRANSPOSE(D5))","v":"Alex Michaelides"},{"$f":"CONCATENATE(C5,\", \",C6)","v":"The Silent Patient, The Maidens"}]

{"sheet":"Notepad","index":10,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of Notepad to Merge Rows",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Sl. No","Book","Author",null,null,null,null,"Sl. No","Book","Author"]
[null,1,"The Silent Patient","Alex Michaelides",null,null,null,null,1,"The Silent Patient","Alex Michaelides"]
[null,2,"The Maidens","Alex Michaelides",null,null,null,null,2,"The Maidens","Alex Michaelides"]
[null,3,"3:00 A.M.","Nick Pirog",null,null,null,null,3,"3:00 A.M.","Nick Pirog"]
[null,4,"3:21 A.M.","Nick Pirog",null,null,null,null,4,"3:21 A.M.","Nick Pirog"]
[null,5,"3:46 A.M.","Nick Pirog",null,null,null,null,5,"3:46 A.M.","Nick Pirog"]
[null,6,"Deadly Cross","James Patterson",null,null,null,null,6,"Deadly Cross","James Patterson"]
[null,7,"The President Is Missing","James Patterson",null,null,null,null,7,"The President Is Missing","James Patterson"]
[null,8,"The Summer House","James Patterson",null,null,null,null,8,"The Summer House","James Patterson"]
[null,9,"Detective Cross","James Patterson",null,null,null,null,9,"Detective Cross","James Patterson"]
[]
[null,"Author","Book",null,null,null,null,null,"Author","Book"]
[null,"James Patterson","Deadly Cross, The President Is Missing, \nThe Summer House, Detective Cross",null,null,null,null,null,"James Patterson"]

{"sheet":"Excel VBA","index":11,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13],[4,3,5,3],[6,3,8,3],[9,3,12,3]]}
[]
[null,"Use of Excel VBA",null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Sl. No","Book","Author",null,null,null,null,null,null,null,"Sl. No","Book","Author"]
[null,1,"The Silent Patient","Alex Michaelides",null,null,null,null,null,null,null,1,"The Silent Patient","Alex Michaelides"]
[null,2,"The Maidens",null,null,null,null,null,null,null,null,2,"The Maidens","Alex Michaelides"]
[null,3,"3:00 A.M.","Nick Pirog",null,null,null,null,null,null,null,3,"3:00 A.M.","Nick Pirog"]
[null,4,"3:21 A.M.",null,null,null,null,null,null,null,null,4,"3:21 A.M.","Nick Pirog"]
[null,5,"3:46 A.M.",null,null,null,null,null,null,null,null,5,"3:46 A.M.","Nick Pirog"]
[null,6,"Deadly Cross","James Patterson",null,null,null,null,null,null,null,6,"Deadly Cross","James Patterson"]
[null,7,"The President Is Missing",null,null,null,null,null,null,null,null,7,"The President Is Missing","James Patterson"]
[null,8,"The Summer House",null,null,null,null,null,null,null,null,8,"The Summer House","James Patterson"]
[null,9,"Detective Cross",null,null,null,null,null,null,null,null,9,"Detective Cross","James Patterson"]