{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset-1","Merge & Center","Format Cells","Keyboard Shortcut","Quick Acces Toolbar","Dataset-2","TEXTJOIN","CONCATENATE","VBA Code","Dataset-3","Merge Rows with Same Values","Merging Rows Based on Criteria","Merging Columns"],"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-1","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Employee Information"]
[]
[null,"Administration"]
[null,"Name","Salary"]
[null,"Emily",2000]
[null,"Jane",2500]
[null,"Tyler",3000]
[null,"Sabine",1900]
[null,"Finance"]
[null,"Name","Salary"]
[null,"Nick",1800]
[null,"Max",2000]
[null,"Wilkins",2500]
[null,"Marketing"]
[null,"Name","Salary"]
[null,"John",2600]
[null,"Gloria",1800]
[null,"Miles",2800]

{"sheet":"Merge & Center","index":1,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[14,1,14,2],[9,1,9,2],[3,1,3,2],[1,11,1,12]]}
[]
[null,"Using Merge and Center Option",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Administration",null,null,null,null,null,null,null,null,null,"Administration"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"Emily",2000,null,null,null,null,null,null,null,null,"Emily",2000]
[null,"Jane",2500,null,null,null,null,null,null,null,null,"Jane",2500]
[null,"Tyler",3000,null,null,null,null,null,null,null,null,"Tyler",3000]
[null,"Sabine",1900,null,null,null,null,null,null,null,null,"Sabine",1900]
[null,"Finance",null,null,null,null,null,null,null,null,null,"Finance"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"Nick",1800,null,null,null,null,null,null,null,null,"Nick",1800]
[null,"Max",2000,null,null,null,null,null,null,null,null,"Max",2000]
[null,"Wilkins",2500,null,null,null,null,null,null,null,null,"Wilkins",2500]
[null,"Marketing",null,null,null,null,null,null,null,null,null,"Marketing"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"John",2600,null,null,null,null,null,null,null,null,"John",2600]
[null,"Gloria",1800,null,null,null,null,null,null,null,null,"Gloria",1800]
[null,"Miles",2800,null,null,null,null,null,null,null,null,"Miles",2800]

{"sheet":"Format Cells","index":2,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2],[9,1,9,2],[14,1,14,2],[1,11,1,12]]}
[]
[null,"Using Format Cells Option",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Administration",null,null,null,null,null,null,null,null,null,"Administration"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"Emily",2000,null,null,null,null,null,null,null,null,"Emily",2000]
[null,"Jane",2500,null,null,null,null,null,null,null,null,"Jane",2500]
[null,"Tyler",3000,null,null,null,null,null,null,null,null,"Tyler",3000]
[null,"Sabine",1900,null,null,null,null,null,null,null,null,"Sabine",1900]
[null,"Finance",null,null,null,null,null,null,null,null,null,"Finance"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"Nick",1800,null,null,null,null,null,null,null,null,"Nick",1800]
[null,"Max",2000,null,null,null,null,null,null,null,null,"Max",2000]
[null,"Wilkins",2500,null,null,null,null,null,null,null,null,"Wilkins",2500]
[null,"Marketing",null,null,null,null,null,null,null,null,null,"Marketing"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"John",2600,null,null,null,null,null,null,null,null,"John",2600]
[null,"Gloria",1800,null,null,null,null,null,null,null,null,"Gloria",1800]
[null,"Miles",2800,null,null,null,null,null,null,null,null,"Miles",2800]

{"sheet":"Keyboard Shortcut","index":3,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2],[14,1,14,2],[9,1,9,2],[1,11,1,12]]}
[]
[null,"Using Keyboard Shortcut",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Administration",null,null,null,null,null,null,null,null,null,"Administration"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"Emily",2000,null,null,null,null,null,null,null,null,"Emily",2000]
[null,"Jane",2500,null,null,null,null,null,null,null,null,"Jane",2500]
[null,"Tyler",3000,null,null,null,null,null,null,null,null,"Tyler",3000]
[null,"Sabine",1900,null,null,null,null,null,null,null,null,"Sabine",1900]
[null,"Finance",null,null,null,null,null,null,null,null,null,"Finance"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"Nick",1800,null,null,null,null,null,null,null,null,"Nick",1800]
[null,"Max",2000,null,null,null,null,null,null,null,null,"Max",2000]
[null,"Wilkins",2500,null,null,null,null,null,null,null,null,"Wilkins",2500]
[null,"Marketing",null,null,null,null,null,null,null,null,null,"Marketing"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"John",2600,null,null,null,null,null,null,null,null,"John",2600]
[null,"Gloria",1800,null,null,null,null,null,null,null,null,"Gloria",1800]
[null,"Miles",2800,null,null,null,null,null,null,null,null,"Miles",2800]

{"sheet":"Quick Acces Toolbar","index":4,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[14,1,14,2],[9,1,9,2],[3,1,3,2],[1,11,1,12]]}
[]
[null,"Using Quick Access Toolbar",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Administration",null,null,null,null,null,null,null,null,null,"Administration"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"Emily",2000,null,null,null,null,null,null,null,null,"Emily",2000]
[null,"Jane",2500,null,null,null,null,null,null,null,null,"Jane",2500]
[null,"Tyler",3000,null,null,null,null,null,null,null,null,"Tyler",3000]
[null,"Sabine",1900,null,null,null,null,null,null,null,null,"Sabine",1900]
[null,"Finance",null,null,null,null,null,null,null,null,null,"Finance"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"Nick",1800,null,null,null,null,null,null,null,null,"Nick",1800]
[null,"Max",2000,null,null,null,null,null,null,null,null,"Max",2000]
[null,"Wilkins",2500,null,null,null,null,null,null,null,null,"Wilkins",2500]
[null,"Marketing",null,null,null,null,null,null,null,null,null,"Marketing"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"John",2600,null,null,null,null,null,null,null,null,"John",2600]
[null,"Gloria",1800,null,null,null,null,null,null,null,null,"Gloria",1800]
[null,"Miles",2800,null,null,null,null,null,null,null,null,"Miles",2800]

{"sheet":"Dataset-2","index":5,"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,"Poor Economics","A. Banarjee"]
[null,"House of Wisdom","Jim Khalili"]
[null,"Purple Cow","Seth Godin"]
[null,"Made to Stick","Chip Heath"]
[null,"The Black Swan","Nassim Taleb"]
[null,"Thinking Fast and Slow","D. Kahneman"]
[null,"Why Nations Fail","J. Robinson"]
[null,"Sapiens","Noah Harari"]

{"sheet":"TEXTJOIN","index":6,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,12]]}
[]
[null,"Using TEXTJOIN Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Merged",null,null,null,null,null,null,null,"Book Name","Author"]
[null,"Poor Economics","A. Banarjee",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,B5:C5)","v":"Poor Economics, A. Banarjee"},null,null,null,null,null,null,null,"Poor Economics","A. Banarjee"]
[null,"House of Wisdom","Jim Khalili","House of Wisdom, Jim Khalili",null,null,null,null,null,null,null,"House of Wisdom","Jim Khalili"]
[null,"Purple Cow","Seth Godin","Purple Cow, Seth Godin",null,null,null,null,null,null,null,"Purple Cow","Seth Godin"]
[null,"Made to Stick","Chip Heath","Made to Stick, Chip Heath",null,null,null,null,null,null,null,"Made to Stick","Chip Heath"]
[null,"The Black Swan","Nassim Taleb","The Black Swan, Nassim Taleb",null,null,null,null,null,null,null,"The Black Swan","Nassim Taleb"]
[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,"Why Nations Fail","J. Robinson","Why Nations Fail, J. Robinson",null,null,null,null,null,null,null,"Why Nations Fail","J. Robinson"]
[null,"Sapiens","Noah Harari","Sapiens, Noah Harari",null,null,null,null,null,null,null,"Sapiens","Noah Harari"]

{"sheet":"CONCATENATE","index":7,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,12]]}
[]
[null,"Using CONCATENATE Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Merged",null,null,null,null,null,null,null,"Book Name","Author"]
[null,"Poor Economics","A. Banarjee",{"$f":"CONCATENATE(B5,\", \",C5)","v":"Poor Economics, A. Banarjee"},null,null,null,null,null,null,null,"Poor Economics","A. Banarjee"]
[null,"House of Wisdom","Jim Khalili",{"$f":"CONCATENATE(B6,\", \",C6)","v":"House of Wisdom, Jim Khalili"},null,null,null,null,null,null,null,"House of Wisdom","Jim Khalili"]
[null,"Purple Cow","Seth Godin","Purple Cow, Seth Godin",null,null,null,null,null,null,null,"Purple Cow","Seth Godin"]
[null,"Made to Stick","Chip Heath","Made to Stick, Chip Heath",null,null,null,null,null,null,null,"Made to Stick","Chip Heath"]
[null,"The Black Swan","Nassim Taleb","The Black Swan, Nassim Taleb",null,null,null,null,null,null,null,"The Black Swan","Nassim Taleb"]
[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,"Why Nations Fail","J. Robinson","Why Nations Fail, J. Robinson",null,null,null,null,null,null,null,"Why Nations Fail","J. Robinson"]
[null,"Sapiens","Noah Harari","Sapiens, Noah Harari",null,null,null,null,null,null,null,"Sapiens","Noah Harari"]

{"sheet":"VBA Code","index":8,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2],[9,1,9,2],[14,1,14,2],[1,11,1,12]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Administration",null,null,null,null,null,null,null,null,null,"Administration"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"Emily",2000,null,null,null,null,null,null,null,null,"Emily",2000]
[null,"Jane",2500,null,null,null,null,null,null,null,null,"Jane",2500]
[null,"Tyler",3000,null,null,null,null,null,null,null,null,"Tyler",3000]
[null,"Sabine",1900,null,null,null,null,null,null,null,null,"Sabine",1900]
[null,"Finance",null,null,null,null,null,null,null,null,null,"Finance"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"Nick",1800,null,null,null,null,null,null,null,null,"Nick",1800]
[null,"Max",2000,null,null,null,null,null,null,null,null,"Max",2000]
[null,"Wilkins",2500,null,null,null,null,null,null,null,null,"Wilkins",2500]
[null,"Marketing",null,null,null,null,null,null,null,null,null,"Marketing"]
[null,"Name","Salary",null,null,null,null,null,null,null,null,"Name","Salary"]
[null,"John",2600,null,null,null,null,null,null,null,null,"John",2600]
[null,"Gloria",1800,null,null,null,null,null,null,null,null,"Gloria",1800]
[null,"Miles",2800,null,null,null,null,null,null,null,null,"Miles",2800]

{"sheet":"Dataset-3","index":9,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sales List"]
[]
[null,"Name","Item","Price"]
[null,"Zach","Formal wear",200]
[null,"Zach","Shoes",150]
[null,"Cooper","Tie",20]
[null,"Cooper","Shirts",25]
[null,"Cooper","Watch",80]
[null,"Dietrich","Denim Jackets",150]
[null,"Dietrich","T-shirt",5]
[null,"Dietrich","Sneaker",30]
[null,"Jane","Shoes",110]
[null,"Jane","Watch",50]

{"sheet":"Merge Rows with Same Values","index":10,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,13]]}
[]
[null,"Merge Rows with Same Values",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Item","Price","Merged Rows ",null,null,null,null,null,null,"Name","Item","Price"]
[null,"Zach","Formal wear",200,{"$f":"IF(B5=B4,E4&\", \"&C5,C5)","v":"Formal wear"},null,null,null,null,null,null,"Zach","Formal wear",200]
[null,"Zach","Shoes",150,{"$f":"IF(B6=B5,E5&\", \"&C6,C6)","v":"Formal wear, Shoes"},null,null,null,null,null,null,"Zach","Shoes",150]
[null,"Cooper","Tie",20,"Tie",null,null,null,null,null,null,"Cooper","Tie",20]
[null,"Cooper","Shirts",25,"Tie, Shirts",null,null,null,null,null,null,"Cooper","Shirts",25]
[null,"Cooper","Watch",80,"Tie, Shirts, Watch",null,null,null,null,null,null,"Cooper","Watch",80]
[null,"Dietrich","Denim Jackets",150,"Denim Jackets",null,null,null,null,null,null,"Dietrich","Denim Jackets",150]
[null,"Dietrich","T-shirt",5,"Denim Jackets, T-shirt",null,null,null,null,null,null,"Dietrich","T-shirt",5]
[null,"Dietrich","Sneaker",30,"Denim Jackets, T-shirt, Sneaker",null,null,null,null,null,null,"Dietrich","Sneaker",30]
[null,"Jane","Shoes",110,"Shoes",null,null,null,null,null,null,"Jane","Shoes",110]
[null,"Jane","Watch",50,"Shoes, Watch",null,null,null,null,null,null,"Jane","Watch",50]

{"sheet":"Merging Rows Based on Criteria","index":11,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,11,1,13],[17,2,17,3],[18,2,18,3],[19,2,19,3],[1,1,1,3],[15,2,15,3],[16,2,16,3]]}
[]
[null,"Merging Rows Based on Criteria",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Item","Price",null,null,null,null,null,null,null,"Name","Item","Price"]
[null,"Zach","Formal wear",200,null,null,null,null,null,null,null,"Zach","Formal wear",200]
[null,"Zach","Shoes",150,null,null,null,null,null,null,null,"Zach","Shoes",150]
[null,"Cooper","Tie",20,null,null,null,null,null,null,null,"Cooper","Tie",20]
[null,"Cooper","Shirts",25,null,null,null,null,null,null,null,"Cooper","Shirts",25]
[null,"Cooper","Watch",80,null,null,null,null,null,null,null,"Cooper","Watch",80]
[null,"Dietrich","Denim Jackets",150,null,null,null,null,null,null,null,"Dietrich","Denim Jackets",150]
[null,"Dietrich","T-shirt",5,null,null,null,null,null,null,null,"Dietrich","T-shirt",5]
[null,"Dietrich","Sneaker",30,null,null,null,null,null,null,null,"Dietrich","Sneaker",30]
[null,"Jane","Shoes",110,null,null,null,null,null,null,null,"Jane","Shoes",110]
[null,"Jane","Watch",50,null,null,null,null,null,null,null,"Jane","Watch",50]
[]
[null,"Name","Total Sales"]
[null,"Zach",350]
[null,"Cooper",125]
[null,"Dietrich",185]
[null,"Jane",160]

{"sheet":"Merging Columns","index":12,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,12]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Merged",null,null,null,null,null,null,null,"Book Name","Author"]
[null,"Poor Economics","A. Banarjee",{"$f":"B5:B12 & \", \" & C5:C12","v":"Poor Economics, A. Banarjee"},null,null,null,null,null,null,null,"Poor Economics","A. Banarjee"]
[null,"House of Wisdom","Jim Khalili","House of Wisdom, Jim Khalili",null,null,null,null,null,null,null,"House of Wisdom","Jim Khalili"]
[null,"Purple Cow","Seth Godin","Purple Cow, Seth Godin",null,null,null,null,null,null,null,"Purple Cow","Seth Godin"]
[null,"Made to Stick","Chip Heath","Made to Stick, Chip Heath",null,null,null,null,null,null,null,"Made to Stick","Chip Heath"]
[null,"The Black Swan","Nassim Taleb","The Black Swan, Nassim Taleb",null,null,null,null,null,null,null,"The Black Swan","Nassim Taleb"]
[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,"Why Nations Fail","J. Robinson","Why Nations Fail, J. Robinson",null,null,null,null,null,null,null,"Why Nations Fail","J. Robinson"]
[null,"Sapiens","Noah Harari","Sapiens, Noah Harari",null,null,null,null,null,null,null,"Sapiens","Noah Harari"]