{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["TEXTJOIN","CONCATENATE TRANSPOSE","TEXTJOIN (2)","TEXTJOIN (3)","Macro","Macro (2)"],"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":"TEXTJOIN","index":0,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Book Record of Kingfisher Bookstore"]
[]
[null,"Author","Name of the Book","Combined Books"]
[null,"Charles Dickens","A Tale of Two Cities",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C4:C7)","v":"A Tale of Two Cities, Great Expectations, Oliver Twist, David Copperfield"}]
[null,null,"Great Expectations"]
[null,null,"Oliver Twist"]
[null,null,"David Copperfield"]
[null,"P. B. Shelly","Ode to the West Wind",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C8:C10)","v":"Ode to the West Wind, To a Skylark, Queen Mab"}]
[null,null,"To a Skylark"]
[null,null,"Queen Mab"]
[null,"Sir H.Rider Haggard","She",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C11:C17)","v":"She, And Return of She, The Virgin of the Sun, The People of the Mist, The Bretheren, Montejuma's Daughter, Pearl Maiden"}]
[null,null,"And Return of She"]
[null,null,"The Virgin of the Sun"]
[null,null,"The People of the Mist"]
[null,null,"The Bretheren"]
[null,null,"Montejuma's Daughter"]
[null,null,"Pearl Maiden"]
[null,"Eliff Shafak","The Forty Rules of Love",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C18:C19)","v":"The Forty Rules of Love, The Bastard of Istambul"}]
[null,null,"The Bastard of Istambul"]
[null,"George Orwell","1984",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C20:C21)","v":"1984, Animal Firm"}]
[null,null,"Animal Firm"]
[null,"Earnest Hemingway","The Old Man and the Sea",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C22:C24)","v":"The Old Man and the Sea, A Farewell to Arms, The Sun Also Rises"}]
[null,null,"A Farewell to Arms"]
[null,null,"The Sun Also Rises"]
[null,"Erik Maria Remark","All Quiet in the Western Front",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C25:C27)","v":"All Quiet in the Western Front, Three Comrades, Night in Lisbon"}]
[null,null,"Three Comrades"]
[null,null,"Night in Lisbon"]

{"sheet":"CONCATENATE TRANSPOSE","index":1,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,3,2,9]]}
["Book Record of Kingfisher Bookstore"]
[]
[null,"Author","Name of the Book","Combined Books"]
[null,"Charles Dickens","A Tale of Two Cities",{"$f":"CONCATENATE(TRANSPOSE(C4:C7))","v":"A Tale of Two Cities"},"Great Expectations","Oliver Twist","David Copperfield"]
[null,null,"Great Expectations"]
[null,null,"Oliver Twist"]
[null,null,"David Copperfield"]
[null,"P. B. Shelly","Ode to the West Wind",{"$f":"CONCATENATE(TRANSPOSE(C8:C10))","v":"Ode to the West Wind"},"To a Skylark","Queen Mab"]
[null,null,"To a Skylark"]
[null,null,"Queen Mab"]
[null,"Sir H.Rider Haggard","She",{"$f":"CONCATENATE(TRANSPOSE(C11:C17))","v":"She"},"And Return of She","The Virgin of the Sun","The People of the Mist","The Bretheren","Montejuma's Daughter","Pearl Maiden"]
[null,null,"And Return of She"]
[null,null,"The Virgin of the Sun"]
[null,null,"The People of the Mist"]
[null,null,"The Bretheren"]
[null,null,"Montejuma's Daughter"]
[null,null,"Pearl Maiden"]
[null,"Eliff Shafak","The Forty Rules of Love",{"$f":"CONCATENATE(TRANSPOSE(C18:C19))","v":"The Forty Rules of Love"},"The Bastard of Istambul"]
[null,null,"The Bastard of Istambul"]
[null,"George Orwell","1984",{"$f":"CONCATENATE(TRANSPOSE(C20:C21))","v":"1984"},"Animal Farm"]
[null,null,"Animal Farm"]
[null,"Earnest Hemingway","The Old Man and the Sea",{"$f":"CONCATENATE(TRANSPOSE(C22:C24))","v":"The Old Man and the Sea"},"A Farewell to Arms","The Sun Also Rises"]
[null,null,"A Farewell to Arms"]
[null,null,"The Sun Also Rises"]
[null,"Erik Maria Remark","All Quiet in the Western Front",{"$f":"CONCATENATE(TRANSPOSE(C25:C27))","v":"All Quiet in the Western Front"},"Three Comrades","Night in Lisbon"]
[null,null,"Three Comrades"]
[null,null,"Night in Lisbon"]

{"sheet":"TEXTJOIN (2)","index":2,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Book Record of Kingfisher Bookstore"]
[]
[null,"Author","Name of the Book",null,"Author","Books"]
[null,"P. B. Shelly","To a Skylark",null,{"$f":"_xlfn.UNIQUE(B4:B27)","v":"P. B. Shelly"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.FILTER(C4:C27,B4:B27=E4))","v":"To a Skylark, Queen Mab, Ode to the West Wind"}]
[null,"Erik Maria Remark","Three Comrades",null,"Erik Maria Remark",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.FILTER(C5:C28,B5:B28=E5))","v":"Three Comrades, Night in Lisbon, All Quiet in the Western Front"}]
[null,"Sir H.Rider Haggard","The Virgin of the Sun",null,"Sir H.Rider Haggard",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.FILTER(C6:C29,B6:B29=E6))","v":"The Virgin of the Sun, The People of the Mist, The Bretheren, She, Pearl Maiden, Montejuma's Daughter, And Return of She"}]
[null,"Earnest Hemingway","The Sun Also Rises",null,"Earnest Hemingway",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.FILTER(C7:C30,B7:B30=E7))","v":"The Sun Also Rises, The Old Man and the Sea, A Farewell to Arms"}]
[null,"Sir H.Rider Haggard","The People of the Mist",null,"Eliff Shafak",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.FILTER(C8:C31,B8:B31=E8))","v":"The Forty Rules of Love, The Bastard of Istambul"}]
[null,"Earnest Hemingway","The Old Man and the Sea",null,"Charles Dickens",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.FILTER(C9:C32,B9:B32=E9))","v":"Oliver Twist, Great Expectations, David Copperfield, A Tale of Two Cities"}]
[null,"Eliff Shafak","The Forty Rules of Love",null,"George Orwell",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.FILTER(C10:C33,B10:B33=E10))","v":"Animal Firm, 1984"}]
[null,"Sir H.Rider Haggard","The Bretheren"]
[null,"Eliff Shafak","The Bastard of Istambul"]
[null,"Sir H.Rider Haggard","She"]
[null,"P. B. Shelly","Queen Mab"]
[null,"Sir H.Rider Haggard","Pearl Maiden"]
[null,"Charles Dickens","Oliver Twist"]
[null,"P. B. Shelly","Ode to the West Wind"]
[null,"Erik Maria Remark","Night in Lisbon"]
[null,"Sir H.Rider Haggard","Montejuma's Daughter"]
[null,"Charles Dickens","Great Expectations"]
[null,"Charles Dickens","David Copperfield"]
[null,"George Orwell","Animal Firm"]
[null,"Sir H.Rider Haggard","And Return of She"]
[null,"Erik Maria Remark","All Quiet in the Western Front"]
[null,"Charles Dickens","A Tale of Two Cities"]
[null,"Earnest Hemingway","A Farewell to Arms"]
[null,"George Orwell","1984"]

{"sheet":"TEXTJOIN (3)","index":3,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Working Schedule of Jupyter Group"]
[]
[null,"Employee Name","Workdays","Combined Workdays"]
[null,"Frank Orwell","Monday",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C4:C7)","v":"Monday, Tuesday, Friday, Saturday"}]
[null,null,"Tuesday"]
[null,null,"Friday"]
[null,null,"Saturday"]
[null,"Natalia Austin","Tuesday",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C8:C11)","v":"Tuesday, Wednesday, Thursday, Sunday"}]
[null,null,"Wednesday"]
[null,null,"Thursday"]
[null,null,"Sunday"]
[null,"Morris Johnson","Sunday",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C12:C15)","v":"Sunday, Wednesday, Thursday, Friday"}]
[null,null,"Wednesday"]
[null,null,"Thursday"]
[null,null,"Friday"]
[null,"Alfred Moyes","Monday",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C16:C19)","v":"Monday, Wednesday, Friday, Sunday"}]
[null,null,"Wednesday"]
[null,null,"Friday"]
[null,null,"Sunday"]
[null,"Angela Hopkins","Wednesday",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C20:C23)","v":"Wednesday, Thursday, Saturday, Sunday"}]
[null,null,"Thursday"]
[null,null,"Saturday"]
[null,null,"Sunday"]

{"sheet":"Macro","index":4,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,26,1],[24,2,26,2],[17,1,18,1],[17,2,18,2],[19,1,20,1],[19,2,20,2],[21,1,23,1],[21,2,23,2],[10,1,16,1],[10,2,16,2],[0,0,0,3],[3,1,6,1],[3,2,6,2],[7,1,9,1],[7,2,9,2]]}
["Book Record of Kingfisher Bookstore"]
[]
[null,"Author","Name of the Book"]
[null,"Charles Dickens","\r\nA Tale of Two Cities\r\nGreat Expectations\r\nOliver Twist\r\nDavid Copperfield"]
[]
[]
[]
[null,"P. B. Shelly","\r\nOde to the West Wind\r\nTo a Skylark\r\nQueen Mab"]
[]
[]
[null,"Sir H.Rider Haggard","\r\nShe\r\nAnd Return of She\r\nThe Virgin of the Sun\r\nThe People of the Mist\r\nThe Bretheren\r\nMontejuma's Daughter\r\nPearl Maiden"]
[]
[]
[]
[]
[]
[]
[null,"Eliff Shafak","\r\nThe Forty Rules of Love\r\nThe Bastard of Istambul"]
[]
[null,"George Orwell","\r\n1984\r\nAnimal Firm"]
[]
[null,"Earnest Hemingway","\r\nThe Old Man and the Sea\r\nA Farewell to Arms\r\nThe Sun Also Rises"]
[]
[]
[null,"Erik Maria Remark","\r\nAll Quiet in the Western Front\r\nThree Comrades\r\nNight in Lisbon"]

{"sheet":"Macro (2)","index":5,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,1,26,1],[20,2,26,2],[12,1,14,1],[12,2,14,2],[15,1,16,1],[15,2,16,2],[17,1,19,1],[17,2,19,2],[0,0,0,3],[3,1,6,1],[3,2,6,2],[7,1,9,1],[7,2,9,2],[10,1,11,1],[10,2,11,2]]}
["Book Record of Kingfisher Bookstore"]
[]
[null,"Author","Name of the Book"]
[null,"Charles Dickens","\r\nOliver Twist\r\nGreat Expectations\r\nDavid Copperfield\r\nA Tale of Two Cities"]
[]
[]
[]
[null,"Earnest Hemingway","\r\nThe Sun Also Rises\r\nThe Old Man and the Sea\r\nA Farewell to Arms"]
[]
[]
[null,"Eliff Shafak","\r\nThe Forty Rules of Love\r\nThe Bastard of Istambul"]
[]
[null,"Erik Maria Remark","\r\nThree Comrades\r\nNight in Lisbon\r\nAll Quiet in the Western Front"]
[]
[]
[null,"George Orwell","\r\nAnimal Firm\r\n1984"]
[]
[null,"P. B. Shelly","\r\nTo a Skylark\r\nQueen Mab\r\nOde to the West Wind"]
[]
[]
[null,"Sir H.Rider Haggard","\r\nThe Virgin of the Sun\r\nThe People of the Mist\r\nThe Bretheren\r\nShe\r\nPearl Maiden\r\nMontejuma's Daughter\r\nAnd Return of She"]