{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Data","Ampersand","CONCATENATE","CONCAT","TEXTJOIN","Flash Fill","Multiple Cells in Rows","TRANSPOSE","VBA Function Result (Columns)","VBA Function Result (Rows)"],"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":"Data","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,2,2,4],[2,1,3,1]]}
["Excel Combine Multiple Cells Into One Separated By Comma"]
[]
[null,"Author","Year"]
[null,null,2019,2020,2021]
[null,"James Patterson","Ali Cross","Deadly Cross","Jailhouse Lawyer"]
[null,"Nick Pirog","3 A.M.","Oz Wimbly and the Elephant Rebellion","Jungle Up"]
[null,"Alex Michaelides","The Silent Patient","The Testaments","The Maidens"]
[null,"Stephen King","The Institute","If It Bleeds","Billy Summers"]
[null,"Joe Hill","Full Throttle","Basketful of Heads","Locke & Key/Sandman"]

{"sheet":"Ampersand","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,3,1],[2,2,2,4],[2,5,3,5]]}
["Excel Combine Multiple Cells Into One Separated By Comma"]
[]
[null,"Author","Year",null,null,"Books"]
[null,null,2019,2020,2021]
[null,"James Patterson","Ali Cross","Deadly Cross","Jailhouse Lawyer",{"$f":"C5&\", \"&D5&\", \"&E5","v":"Ali Cross, Deadly Cross, Jailhouse Lawyer"}]
[null,"Nick Pirog","3 A.M.","Oz Wimbly and the Elephant Rebellion","Jungle Up",{"$f":"C6&\", \"&D6&\", \"&E6","v":"3 A.M., Oz Wimbly and the Elephant Rebellion, Jungle Up"}]
[null,"Alex Michaelides","The Silent Patient","The Testaments","The Maidens","The Silent Patient, The Testaments, The Maidens"]
[null,"Stephen King","The Institute","If It Bleeds","Billy Summers","The Institute, If It Bleeds, Billy Summers"]
[null,"Joe Hill","Full Throttle","Basketful of Heads","Locke & Key/Sandman","Full Throttle, Basketful of Heads, Locke & Key/Sandman"]

{"sheet":"CONCATENATE","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,3,1],[2,2,2,4],[2,5,3,5]]}
["Excel Combine Multiple Cells Into One Separated By Comma"]
[]
[null,"Author","Year",null,null,"Books"]
[null,null,2019,2020,2021]
[null,"James Patterson","Ali Cross","Deadly Cross","Jailhouse Lawyer",{"$f":"CONCATENATE(C5,\", \",D5,\", \",E5)","v":"Ali Cross, Deadly Cross, Jailhouse Lawyer"}]
[null,"Nick Pirog","3 A.M.","Oz Wimbly and the Elephant Rebellion","Jungle Up",{"$f":"CONCATENATE(C6,\", \",D6,\", \",E6)","v":"3 A.M., Oz Wimbly and the Elephant Rebellion, Jungle Up"}]
[null,"Alex Michaelides","The Silent Patient","The Testaments","The Maidens","The Silent Patient, The Testaments, The Maidens"]
[null,"Stephen King","The Institute","If It Bleeds","Billy Summers","The Institute, If It Bleeds, Billy Summers"]
[null,"Joe Hill","Full Throttle","Basketful of Heads","Locke & Key/Sandman","Full Throttle, Basketful of Heads, Locke & Key/Sandman"]

{"sheet":"CONCAT","index":3,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,3,1],[2,2,2,4],[2,5,3,5]]}
["Excel Combine Multiple Cells Into One Separated By Comma"]
[]
[null,"Author","Year",null,null,"Books"]
[null,null,2019,2020,2021]
[null,"James Patterson","Ali Cross","Deadly Cross","Jailhouse Lawyer",{"$f":"_xlfn.CONCAT(C5,\", \",D5,\", \",E5)","v":"Ali Cross, Deadly Cross, Jailhouse Lawyer"}]
[null,"Nick Pirog","3 A.M.","Oz Wimbly and the Elephant Rebellion","Jungle Up",{"$f":"_xlfn.CONCAT(C6,\", \",D6,\", \",E6)","v":"3 A.M., Oz Wimbly and the Elephant Rebellion, Jungle Up"}]
[null,"Alex Michaelides","The Silent Patient","The Testaments","The Maidens","The Silent Patient, The Testaments, The Maidens"]
[null,"Stephen King","The Institute","If It Bleeds","Billy Summers","The Institute, If It Bleeds, Billy Summers"]
[null,"Joe Hill","Full Throttle","Basketful of Heads","Locke & Key/Sandman","Full Throttle, Basketful of Heads, Locke & Key/Sandman"]

{"sheet":"TEXTJOIN","index":4,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,3,1],[2,2,2,4],[2,5,3,5]]}
["Excel Combine Multiple Cells Into One Separated By Comma"]
[]
[null,"Author","Year",null,null,"Books"]
[null,null,2019,2020,2021]
[null,"James Patterson","Ali Cross","Deadly Cross","Jailhouse Lawyer",{"$f":"_xlfn.TEXTJOIN(\", \",1,C5:E5)","v":"Ali Cross, Deadly Cross, Jailhouse Lawyer"}]
[null,"Nick Pirog","3 A.M.","Oz Wimbly and the Elephant Rebellion","Jungle Up",{"$f":"_xlfn.TEXTJOIN(\", \",1,C6:E6)","v":"3 A.M., Oz Wimbly and the Elephant Rebellion, Jungle Up"}]
[null,"Alex Michaelides","The Silent Patient","The Testaments","The Maidens","The Silent Patient, The Testaments, The Maidens"]
[null,"Stephen King","The Institute","If It Bleeds","Billy Summers","The Institute, If It Bleeds, Billy Summers"]
[null,"Joe Hill","Full Throttle","Basketful of Heads","Locke & Key/Sandman","Full Throttle, Basketful of Heads, Locke & Key/Sandman"]

{"sheet":"Flash Fill","index":5,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,3,1],[2,2,2,4],[2,5,3,5]]}
["Excel Combine Multiple Cells Into One Separated By Comma"]
[]
[null,"Author","Year",null,null,"Books"]
[null,null,2019,2020,2021]
[null,"James Patterson","Ali Cross","Deadly Cross","Jailhouse Lawyer","Ali Cross, Deadly Cross, Jailhouse Lawyer"]
[null,"Nick Pirog","3 A.M.","Oz Wimbly and the Elephant Rebellion","Jungle Up","3 A.M., Oz Wimbly and the Elephant Rebellion, Jungle Up"]
[null,"Alex Michaelides","The Silent Patient","The Testaments","The Maidens","The Silent Patient, The Testaments, The Maidens"]
[null,"Stephen King","The Institute","If It Bleeds","Billy Summers","The Institute, If It Bleeds, Billy Summers"]
[null,"Joe Hill","Full Throttle","Basketful of Heads","Locke & Key/Sandman","Full Throttle, Basketful of Heads, Locke & Key/Sandman"]

{"sheet":"Multiple Cells in Rows","index":6,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,1,14,1],[12,3,14,3],[15,1,17,1],[15,3,17,3],[3,1,5,1],[3,3,5,3],[6,1,8,1],[6,3,8,3],[9,1,11,1],[9,3,11,3]]}
["Excel Combine Multiple Cells Into One Separated By Comma"]
[]
[null,"Author","Book Name","All Books"]
[null,"James Patterson","Ali Cross",{"$f":"CONCATENATE(C4,\", \",C5,\", \",C6)","v":"Ali Cross, Deadly Cross, Jailhouse Lawyer"}]
[null,null,"Deadly Cross"]
[null,null,"Jailhouse Lawyer"]
[null,"Nick Pirog","3 A.M.",{"$f":"_xlfn.CONCAT(C7,\", \",C8,\", \",C9)","v":"3 A.M., Oz Wimbly and the Elephant Rebellion, Jungle Up"}]
[null,null,"Oz Wimbly and the Elephant Rebellion"]
[null,null,"Jungle Up"]
[null,"Alex Michaelides","The Silent Patient",{"$f":"CONCATENATE(C10,\", \",C11,\", \",C12)","v":"The Silent Patient, The Testaments, The Maidens"}]
[null,null,"The Testaments"]
[null,null,"The Maidens"]
[null,"Stephen King","The Institute",{"$f":"CONCATENATE(C13,\", \",C14,\", \",C15)","v":"The Institute, If It Bleeds, Billy Summers"}]
[null,null,"If It Bleeds"]
[null,null,"Billy Summers"]
[null,"Joe Hill","Full Throttle",{"$f":"CONCATENATE(C16,\", \",C17,\", \",C18)","v":"Full Throttle, Basketful of Heads, Locke & Key/Sandman"}]
[null,null,"Basketful of Heads"]
[null,null,"Locke & Key/Sandman"]

{"sheet":"TRANSPOSE","index":7,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,3,14,3],[15,3,17,3],[3,1,5,1],[6,1,8,1],[9,1,11,1],[15,1,17,1],[12,1,14,1],[3,3,5,3],[6,3,8,3],[9,3,11,3]]}
["Excel Combine Multiple Cells Into One Separated By Comma"]
[]
[null,"Author","Book Name","All Books"]
[null,"James Patterson","Ali Cross",{"$f":"CONCATENATE(\"Ali Cross, \",\"Deadly Cross, \",\"Jailhouse Lawyer\")","v":"Ali Cross, Deadly Cross, Jailhouse Lawyer"}]
[null,null,"Deadly Cross"]
[null,null,"Jailhouse Lawyer"]
[null,"Nick Pirog","3 A.M.",{"$f":"_xlfn.CONCAT(\"3 A.M., \",\"Oz Wimbly and the Elephant Rebellion, \",\"Jungle Up\")","v":"3 A.M., Oz Wimbly and the Elephant Rebellion, Jungle Up"}]
[null,null,"Oz Wimbly and the Elephant Rebellion"]
[null,null,"Jungle Up"]
[null,"Alex Michaelides","The Silent Patient",{"$f":"CONCATENATE(\"The Silent Patient, \",\"The Testaments, \",\"The Maidens\")","v":"The Silent Patient, The Testaments, The Maidens"}]
[null,null,"The Testaments"]
[null,null,"The Maidens"]
[null,"Stephen King","The Institute",{"$f":"CONCATENATE(\"The Institute, \",\"If It Bleeds, \",\"Billy Summers\")","v":"The Institute, If It Bleeds, Billy Summers"}]
[null,null,"If It Bleeds"]
[null,null,"Billy Summers"]
[null,"Joe Hill","Full Throttle",{"$f":"CONCATENATE(\"Full Throttle, \",\"Basketful of Heads, \",\"Locke & Key/Sandman\")","v":"Full Throttle, Basketful of Heads, Locke & Key/Sandman"}]
[null,null,"Basketful of Heads"]
[null,null,"Locke & Key/Sandman"]

{"sheet":"VBA Function Result (Columns)","index":8,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,3,1],[2,2,2,4],[2,5,3,5]]}
["Excel Combine Multiple Cells Into One Separated By Comma"]
[]
[null,"Author","Year",null,null,"Books"]
[null,null,2019,2020,2021]
[null,"James Patterson","Ali Cross","Deadly Cross","Jailhouse Lawyer",{"$f":"Combine(C5:E5)","v":"Ali Cross, Deadly Cross, Jailhouse Lawyer"}]
[null,"Nick Pirog","3 A.M.","Oz Wimbly and the Elephant Rebellion","Jungle Up",{"$f":"Combine(C6:E6)","v":"3 A.M., Oz Wimbly and the Elephant Rebellion, Jungle Up"}]
[null,"Alex Michaelides","The Silent Patient","The Testaments","The Maidens","The Silent Patient, The Testaments, The Maidens"]
[null,"Stephen King","The Institute","If It Bleeds","Billy Summers","The Institute, If It Bleeds, Billy Summers"]
[null,"Joe Hill","Full Throttle","Basketful of Heads","Locke & Key/Sandman","Full Throttle, Basketful of Heads, Locke & Key/Sandman"]

{"sheet":"VBA Function Result (Rows)","index":9,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,1,14,1],[12,3,14,3],[15,1,17,1],[15,3,17,3],[3,1,5,1],[3,3,5,3],[6,1,8,1],[6,3,8,3],[9,1,11,1],[9,3,11,3]]}
["Excel Combine Multiple Cells Into One Separated By Comma"]
[]
[null,"Author","Book Name","All Books"]
[null,"James Patterson","Ali Cross",{"$f":"Combine(C4:C6)","v":"Ali Cross, Deadly Cross, Jailhouse Lawyer"}]
[null,null,"Deadly Cross"]
[null,null,"Jailhouse Lawyer"]
[null,"Nick Pirog","3 A.M.",{"$f":"Combine(C7:C9)","v":"3 A.M., Oz Wimbly and the Elephant Rebellion, Jungle Up"}]
[null,null,"Oz Wimbly and the Elephant Rebellion"]
[null,null,"Jungle Up"]
[null,"Alex Michaelides","The Silent Patient",{"$f":"Combine(C10:C12)","v":"The Silent Patient, The Testaments, The Maidens"}]
[null,null,"The Testaments"]
[null,null,"The Maidens"]
[null,"Stephen King","The Institute",{"$f":"Combine(C13:C15)","v":"The Institute, If It Bleeds, Billy Summers"}]
[null,null,"If It Bleeds"]
[null,null,"Billy Summers"]
[null,"Joe Hill","Full Throttle",{"$f":"Combine(C16:C18)","v":"Full Throttle, Basketful of Heads, Locke & Key/Sandman"}]
[null,null,"Basketful of Heads"]
[null,null,"Locke & Key/Sandman"]