{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","CONCATENATE Function","CONCAT Function","TEXTJOIN Function","Ampersand Operator","Flash Fill Option","Notepad","VBA Code"],"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":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Best Sellers"]
[]
[null,"Book Name","Author"]
[null,"The Black Swan","N. Taleb"]
[null,"Psychology of Money","M. Housel"]
[null,"House of Wisdom","J. Khalili"]
[null,"Why Nations Fail","J. Robinson"]
[null,"Prisoners of Geography","T. Marshall"]
[null,"Never Split the Difference","C. Voss"]
[null,"Thinking, Fast and Slow","D. Kahneman"]
[null,"Freakonomics","S. Levitt"]

{"sheet":"CONCATENATE Function","index":1,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using CONCATENATE Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Merged Output",null,null,null,null,null,null,null,"Book Name","Author","Merged Output"]
[null,"The Black Swan","N. Taleb",{"$f":"CONCATENATE(B5,\" - \",C5)","v":"The Black Swan - N. Taleb"},null,null,null,null,null,null,null,"The Black Swan","N. Taleb"]
[null,"Psychology of Money","M. Housel",{"$f":"CONCATENATE(B6,\" - \",C6)","v":"Psychology of Money - M. Housel"},null,null,null,null,null,null,null,"Psychology of Money","M. Housel"]
[null,"House of Wisdom","J. Khalili","House of Wisdom - J. Khalili",null,null,null,null,null,null,null,"House of Wisdom","J. Khalili"]
[null,"Why Nations Fail","J. Robinson","Why Nations Fail - J. Robinson",null,null,null,null,null,null,null,"Why Nations Fail","J. Robinson"]
[null,"Prisoners of Geography","T. Marshall","Prisoners of Geography - T. Marshall",null,null,null,null,null,null,null,"Prisoners of Geography","T. Marshall"]
[null,"Never Split the Difference","C. Voss","Never Split the Difference - C. Voss",null,null,null,null,null,null,null,"Never Split the Difference","C. Voss"]
[null,"Thinking, Fast and Slow","D. Kahneman","Thinking, Fast and Slow - D. Kahneman",null,null,null,null,null,null,null,"Thinking, Fast and Slow","D. Kahneman"]
[null,"Freakonomics","S. Levitt","Freakonomics - S. Levitt",null,null,null,null,null,null,null,"Freakonomics","S. Levitt"]

{"sheet":"CONCAT Function","index":2,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using CONCAT Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Merged Output",null,null,null,null,null,null,null,"Book Name","Author","Merged Output"]
[null,"The Black Swan","N. Taleb",{"$f":"_xlfn.CONCAT(B5,\" - \",C5)","v":"The Black Swan - N. Taleb"},null,null,null,null,null,null,null,"The Black Swan","N. Taleb"]
[null,"Psychology of Money","M. Housel",{"$f":"_xlfn.CONCAT(B6,\" - \",C6)","v":"Psychology of Money - M. Housel"},null,null,null,null,null,null,null,"Psychology of Money","M. Housel"]
[null,"House of Wisdom","J. Khalili","House of Wisdom - J. Khalili",null,null,null,null,null,null,null,"House of Wisdom","J. Khalili"]
[null,"Why Nations Fail","J. Robinson","Why Nations Fail - J. Robinson",null,null,null,null,null,null,null,"Why Nations Fail","J. Robinson"]
[null,"Prisoners of Geography","T. Marshall","Prisoners of Geography - T. Marshall",null,null,null,null,null,null,null,"Prisoners of Geography","T. Marshall"]
[null,"Never Split the Difference","C. Voss","Never Split the Difference - C. Voss",null,null,null,null,null,null,null,"Never Split the Difference","C. Voss"]
[null,"Thinking, Fast and Slow","D. Kahneman","Thinking, Fast and Slow - D. Kahneman",null,null,null,null,null,null,null,"Thinking, Fast and Slow","D. Kahneman"]
[null,"Freakonomics","S. Levitt","Freakonomics - S. Levitt",null,null,null,null,null,null,null,"Freakonomics","S. Levitt"]

{"sheet":"TEXTJOIN Function","index":3,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using TEXTJOIN Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Merged Output",null,null,null,null,null,null,null,"Book Name","Author","Merged Output"]
[null,"The Black Swan","N. Taleb",{"$f":"_xlfn.TEXTJOIN(\" - \",TRUE,B5,C5)","v":"The Black Swan - N. Taleb"},null,null,null,null,null,null,null,"The Black Swan","N. Taleb"]
[null,"Psychology of Money","M. Housel",{"$f":"_xlfn.TEXTJOIN(\" - \",TRUE,B6,C6)","v":"Psychology of Money - M. Housel"},null,null,null,null,null,null,null,"Psychology of Money","M. Housel"]
[null,"House of Wisdom","J. Khalili","House of Wisdom - J. Khalili",null,null,null,null,null,null,null,"House of Wisdom","J. Khalili"]
[null,"Why Nations Fail","J. Robinson","Why Nations Fail - J. Robinson",null,null,null,null,null,null,null,"Why Nations Fail","J. Robinson"]
[null,"Prisoners of Geography","T. Marshall","Prisoners of Geography - T. Marshall",null,null,null,null,null,null,null,"Prisoners of Geography","T. Marshall"]
[null,"Never Split the Difference","C. Voss","Never Split the Difference - C. Voss",null,null,null,null,null,null,null,"Never Split the Difference","C. Voss"]
[null,"Thinking, Fast and Slow","D. Kahneman","Thinking, Fast and Slow - D. Kahneman",null,null,null,null,null,null,null,"Thinking, Fast and Slow","D. Kahneman"]
[null,"Freakonomics","S. Levitt","Freakonomics - S. Levitt",null,null,null,null,null,null,null,"Freakonomics","S. Levitt"]

{"sheet":"Ampersand Operator","index":4,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Merged Output",null,null,null,null,null,null,null,"Book Name","Author","Merged Output"]
[null,"The Black Swan","N. Taleb",{"$f":"B5&\" - \"&C5","v":"The Black Swan - N. Taleb"},null,null,null,null,null,null,null,"The Black Swan","N. Taleb"]
[null,"Psychology of Money","M. Housel",{"$f":"B6&\" - \"&C6","v":"Psychology of Money - M. Housel"},null,null,null,null,null,null,null,"Psychology of Money","M. Housel"]
[null,"House of Wisdom","J. Khalili","House of Wisdom - J. Khalili",null,null,null,null,null,null,null,"House of Wisdom","J. Khalili"]
[null,"Why Nations Fail","J. Robinson","Why Nations Fail - J. Robinson",null,null,null,null,null,null,null,"Why Nations Fail","J. Robinson"]
[null,"Prisoners of Geography","T. Marshall","Prisoners of Geography - T. Marshall",null,null,null,null,null,null,null,"Prisoners of Geography","T. Marshall"]
[null,"Never Split the Difference","C. Voss","Never Split the Difference - C. Voss",null,null,null,null,null,null,null,"Never Split the Difference","C. Voss"]
[null,"Thinking, Fast and Slow","D. Kahneman","Thinking, Fast and Slow - D. Kahneman",null,null,null,null,null,null,null,"Thinking, Fast and Slow","D. Kahneman"]
[null,"Freakonomics","S. Levitt","Freakonomics - S. Levitt",null,null,null,null,null,null,null,"Freakonomics","S. Levitt"]

{"sheet":"Flash Fill Option","index":5,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using Flash Fill Option",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Merged Output",null,null,null,null,null,null,null,"Book Name","Author","Merged Output"]
[null,"The Black Swan","N. Taleb","The Black Swan - N. Taleb",null,null,null,null,null,null,null,"The Black Swan","N. Taleb"]
[null,"Psychology of Money","M. Housel","Psychology of Money - M. Housel",null,null,null,null,null,null,null,"Psychology of Money","M. Housel"]
[null,"House of Wisdom","J. Khalili","House of Wisdom - J. Khalili",null,null,null,null,null,null,null,"House of Wisdom","J. Khalili"]
[null,"Why Nations Fail","J. Robinson","Why Nations Fail - J. Robinson",null,null,null,null,null,null,null,"Why Nations Fail","J. Robinson"]
[null,"Prisoners of Geography","T. Marshall","Prisoners of Geography - T. Marshall",null,null,null,null,null,null,null,"Prisoners of Geography","T. Marshall"]
[null,"Never Split the Difference","C. Voss","Never Split the Difference - C. Voss",null,null,null,null,null,null,null,"Never Split the Difference","C. Voss"]
[null,"Thinking, Fast and Slow","D. Kahneman","Thinking, Fast and Slow - D. Kahneman",null,null,null,null,null,null,null,"Thinking, Fast and Slow","D. Kahneman"]
[null,"Freakonomics","S. Levitt","Freakonomics - S. Levitt",null,null,null,null,null,null,null,"Freakonomics","S. Levitt"]

{"sheet":"Notepad","index":6,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using Notepad to Merge Cells with Data",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Merged Output",null,null,null,null,null,null,null,"Book Name","Author","Merged Output"]
[null,"The Black Swan","N. Taleb","The Black Swan-N. Taleb",null,null,null,null,null,null,null,"The Black Swan","N. Taleb"]
[null,"Psychology of Money","M. Housel","Psychology of Money-M. Housel",null,null,null,null,null,null,null,"Psychology of Money","M. Housel"]
[null,"House of Wisdom","J. Khalili","House of Wisdom-J. Khalili",null,null,null,null,null,null,null,"House of Wisdom","J. Khalili"]
[null,"Why Nations Fail","J. Robinson","Why Nations Fail-J. Robinson",null,null,null,null,null,null,null,"Why Nations Fail","J. Robinson"]
[null,"Prisoners of Geography","T. Marshall","Prisoners of Geography-T. Marshall",null,null,null,null,null,null,null,"Prisoners of Geography","T. Marshall"]
[null,"Never Split the Difference","C. Voss","Never Split the Difference-C. Voss",null,null,null,null,null,null,null,"Never Split the Difference","C. Voss"]
[null,"Thinking, Fast and Slow","D. Kahneman","Thinking, Fast and Slow-D. Kahneman",null,null,null,null,null,null,null,"Thinking, Fast and Slow","D. Kahneman"]
[null,"Freakonomics","S. Levitt","Freakonomics-S. Levitt",null,null,null,null,null,null,null,"Freakonomics","S. Levitt"]

{"sheet":"VBA Code","index":7,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,11,1,13],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[3,3,3,4],[1,1,1,4],[4,3,4,4],[5,3,5,4],[6,3,6,4]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Merged Output",null,null,null,null,null,null,null,"Book Name","Author","Merged Output"]
[null,"The Black Swan","N. Taleb","The Black Swan N. Taleb",null,null,null,null,null,null,null,"The Black Swan","N. Taleb"]
[null,"Psychology of Money","M. Housel","Psychology of Money M. Housel",null,null,null,null,null,null,null,"Psychology of Money","M. Housel"]
[null,"House of Wisdom","J. Khalili","House of Wisdom J. Khalili",null,null,null,null,null,null,null,"House of Wisdom","J. Khalili"]
[null,"Why Nations Fail","J. Robinson","Why Nations Fail J. Robinson",null,null,null,null,null,null,null,"Why Nations Fail","J. Robinson"]
[null,"Prisoners of Geography","T. Marshall","Prisoners of Geography T. Marshall",null,null,null,null,null,null,null,"Prisoners of Geography","T. Marshall"]
[null,"Never Split the Difference","C. Voss","Never Split the Difference C. Voss",null,null,null,null,null,null,null,"Never Split the Difference","C. Voss"]
[null,"Thinking, Fast and Slow","D. Kahneman","Thinking, Fast and Slow D. Kahneman",null,null,null,null,null,null,null,"Thinking, Fast and Slow","D. Kahneman"]
[null,"Freakonomics","S. Levitt","Freakonomics S. Levitt",null,null,null,null,null,null,null,"Freakonomics","S. Levitt"]