{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Old Overview","Overview","0.Dataset","1. Text to Column Feature","Table5","2. Use of VBA","3. Power Query","Practice Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[[1,1,1,2]]}
[]
[null,"Name of Author"]
[]
[null,"Book Name","Author"]
[null,"Adventures of Tom Sawyer"," Mark Twain"]
[null,"The Merchant of Venice"," Shakespeare,Lewis Carrol"]
[null,"Alice in Wonderland"]
[null,"Around the World in eighty days","Jules Verne "]
[null,"Pride and Prejudice","Jane Austen"]
[null,"Adventures of Sherlock Holmes"," Arthur Conan Doyle"]
[null,"Count of Monte Cristo","Alexander Dumas,R.N.Tagore"]
[null,"Bisarjan"]
[null,"Divine Comedy","Dante"]

{"sheet":"Old Overview","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":true,"merged":[[3,1,3,2],[3,4,3,5],[1,1,1,5]]}
[]
[null,"Overview of Splitting Cells into Two Rows"]
[]
[null,"Before Splitting",null,null,"After Splitting"]
[]
[null,"Book Name","Author",null,"Book Name","Author"]
[null,"Adventures of Tom Sawyer"," Mark Twain",null,"Adventures of Tom Sawyer"," Mark Twain"]
[null,"The Merchant of Venice"," Shakespeare,Lewis Carrol",null,"The Merchant of Venice"," Shakespeare"]
[null,"Alice in Wonderland",null,null,"Alice in Wonderland","Lewis Carrol"]
[null,"Around the World in eighty days","Jules Verne ",null,"Around the World in eighty days","Jules Verne "]
[null,"Pride and Prejudice","Jane Austen",null,"Pride and Prejudice","Jane Austen"]
[null,"Adventures of Sherlock Holmes"," Arthur Conan Doyle",null,"Adventures of Sherlock Holmes"," Arthur Conan Doyle"]
[null,"Count of Monte Cristo","Alexander Dumas,R.N.Tagore",null,"Count of Monte Cristo","Alexander Dumas"]
[null,"Bisarjan",null,null,"Bisarjan","R.N.Tagore"]
[null,"Divine Comedy","Dante",null,"Divine Comedy","Dante"]

{"sheet":"Overview","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,2],[3,4,3,5]]}
[]
[null,"Overview of Splitting Cells into Two Rows"]
[]
[null,"Before Splitting",null,null,"After Splitting"]
[]
[null,"Author","Book Name",null,"Author","Book Name"]
[null," Mark Twain","Eye Openers, Screamers",null," Mark Twain","Eye Openers"]
[null," Mark Twain",null,null," Mark Twain","Screamers"]
[null," Shakespeare","The Merchant of Venice, The Tempest",null," Shakespeare","The Merchant of Venice"]
[null," Shakespeare",null,null," Shakespeare","The Tempest"]
[null,"Dante","Divine Comedy",null,"Dante","Divine Comedy"]
[null,"Lewis Carrol","Alice in Wonderland, The Game of Logic",null,"Lewis Carrol","Alice in Wonderland"]
[null,"Lewis Carrol",null,null,"Lewis Carrol","The Game of Logic"]
[null,"Jane Austen","Pride and Prejudice",null,"Jane Austen","Pride and Prejudice"]

{"sheet":"0.Dataset","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Authors & Books"]
[]
[null,"Author","Book Name"]
[null," Mark Twain","Eye Openers, Screamers"]
[null," Mark Twain"]
[null," Shakespeare","The Merchant of Venice, The Tempest"]
[null," Shakespeare"]
[null,"Dante","Divine Comedy"]
[null,"Lewis Carrol","Alice in Wonderland, The Game of Logic"]
[null,"Lewis Carrol"]
[null,"Jane Austen","Pride and Prejudice"]

{"sheet":"1. Text to Column Feature","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Text to Columns Feature"]
[]
[null,"Author","Book Name"]
[null," Mark Twain","Eye Openers"," Screamers"]
[null," Mark Twain",{"$f":"TRANSPOSE(D5)","v":" Screamers"}]
[null," Shakespeare","The Merchant of Venice","The Tempest"]
[null," Shakespeare",{"$f":"TRANSPOSE(D7)","v":"The Tempest"}]
[null,"Dante","Divine Comedy"]
[null,"Lewis Carrol","Alice in Wonderland","The Game of Logic"]
[null,"Lewis Carrol",{"$f":"TRANSPOSE(D10)","v":"The Game of Logic"}]
[null,"Jane Austen","Pride and Prejudice"]

{"sheet":"Table5","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Author","Book Name"]
[" Mark Twain","Eye Openers"]
[" Mark Twain"," Screamers"]
[" Shakespeare","The Merchant of Venice"]
[" Shakespeare"," The Tempest"]
["Dante","Divine Comedy"]
["Lewis Carrol","Alice in Wonderland"]
["Lewis Carrol"," The Game of Logic"]
["Jane Austen","Pride and Prejudice"]

{"sheet":"2. Use of VBA","index":6,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA to Split Cell"]
[]
[null,"Author","Book Name"]
[null," Mark Twain","Eye Openers"]
[null," Mark Twain"," Screamers"]
[null," Shakespeare","The Merchant of Venice"]
[null," Shakespeare"," The Tempest"]
[null,"Dante","Divine Comedy"]
[null,"Lewis Carrol","Alice in Wonderland"]
[null,"Lewis Carrol"," The Game of Logic"]
[null,"Jane Austen","Pride and Prejudice"]

{"sheet":"3. Power Query","index":7,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Power Query"]
[]
[null,"Author","Book Name"]
[null," Mark Twain","Eye Openers"]
[null," Mark Twain"," Screamers"]
[null," Shakespeare","The Merchant of Venice"]
[null," Shakespeare"," The Tempest"]
[null,"Dante","Divine Comedy"]
[null,"Lewis Carrol","Alice in Wonderland"]
[null,"Lewis Carrol"," The Game of Logic"]
[null,"Jane Austen","Pride and Prejudice"]

{"sheet":"Practice Sheet","index":8,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Do It Yourself"]
[]
[null,"Author","Book Name"]
[null," Mark Twain","Eye Openers, Screamers"]
[null," Mark Twain"]
[null," Shakespeare","The Merchant of Venice, The Tempest"]
[null," Shakespeare"]
[null,"Dante","Divine Comedy"]
[null,"Lewis Carrol","Alice in Wonderland, The Game of Logic"]
[null,"Lewis Carrol"]
[null,"Jane Austen","Pride and Prejudice"]