{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset 1","CONCAT","TEXTJOIN","Ampersand","VBA Macro","Dataset 2","One Column Over Another","Dataset 3","Without Losing Data"],"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":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[3,1,4,1],[3,2,3,3],[1,1,1,3],[12,2,12,3],[13,2,13,3]]}
[]
[null,"Addresses of Employees of ABC Company"]
[]
[null,"Name","Address"]
[null,null,"Street","City"]
[null,"Harry Maguire","17640 Kentfield St","Detroit"]
[null,"Ben Davies","33 Witherspoon St","Princeton"]
[null,"Gareth Southgate","1701 Snows Mill Rd","Bogart"]
[null,"Aaron Ramsey","52 Potter Pond","Lexington"]
[null,"Leon Bailey","905 Robertson St","Kingsport"]
[null,"Scott Mctominay","1541 S Main St","Willits"]
[]
[null,"Name","Address"]
[null,"Harry Maguire"]
[null,"Ben Davies"]
[null,"Gareth Southgate"]
[null,"Aaron Ramsey"]
[null,"Leon Bailey"]
[null,"Scott Mctominay"]

{"sheet":"CONCAT","index":1,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[1,10,1,12],[3,10,4,10],[3,11,3,12],[12,11,12,12],[13,11,13,12],[17,2,17,3],[18,2,18,3],[1,1,1,3],[3,1,4,1],[3,2,3,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3]]}
[]
[null,"Applying CONCAT Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Name","Address",null,null,null,null,null,null,null,"Name","Address"]
[null,null,"Street","City",null,null,null,null,null,null,null,"Street","City"]
[null,"Harry Maguire","17640 Kentfield St","Detroit",null,null,null,null,null,null,"Harry Maguire","17640 Kentfield St","Detroit"]
[null,"Ben Davies","33 Witherspoon St","Princeton",null,null,null,null,null,null,"Ben Davies","33 Witherspoon St","Princeton"]
[null,"Gareth Southgate","1701 Snows Mill Rd","Bogart",null,null,null,null,null,null,"Gareth Southgate","1701 Snows Mill Rd","Bogart"]
[null,"Aaron Ramsey","52 Potter Pond","Lexington",null,null,null,null,null,null,"Aaron Ramsey","52 Potter Pond","Lexington"]
[null,"Leon Bailey","905 Robertson St","Kingsport",null,null,null,null,null,null,"Leon Bailey","905 Robertson St","Kingsport"]
[null,"Scott Mctominay","1541 S Main St","Willits",null,null,null,null,null,null,"Scott Mctominay","1541 S Main St","Willits"]
[]
[null,"Name","Address",null,null,null,null,null,null,null,"Name","Address"]
[null,"Harry Maguire",{"$f":"_xlfn.CONCAT(C6,\", \",D6)","v":"17640 Kentfield St, Detroit"},null,null,null,null,null,null,null,"Harry Maguire"]
[null,"Ben Davies",{"$f":"_xlfn.CONCAT(C7,\", \",D7)","v":"33 Witherspoon St, Princeton"},null,null,null,null,null,null,null,"Ben Davies"]
[null,"Gareth Southgate","1701 Snows Mill Rd, Bogart",null,null,null,null,null,null,null,"Gareth Southgate"]
[null,"Aaron Ramsey","52 Potter Pond, Lexington",null,null,null,null,null,null,null,"Aaron Ramsey"]
[null,"Leon Bailey","905 Robertson St, Kingsport",null,null,null,null,null,null,null,"Leon Bailey"]
[null,"Scott Mctominay","1541 S Main St, Willits",null,null,null,null,null,null,null,"Scott Mctominay"]

{"sheet":"TEXTJOIN","index":2,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[1,10,1,12],[3,10,4,10],[3,11,3,12],[12,11,12,12],[13,11,13,12],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[1,1,1,3],[3,1,4,1],[3,2,3,3],[12,2,12,3],[13,2,13,3],[14,2,14,3]]}
[]
[null,"Applying TEXTJOIN Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Name","Address",null,null,null,null,null,null,null,"Name","Address"]
[null,null,"Street","City",null,null,null,null,null,null,null,"Street","City"]
[null,"Harry Maguire","17640 Kentfield St","Detroit",null,null,null,null,null,null,"Harry Maguire","17640 Kentfield St","Detroit"]
[null,"Ben Davies","33 Witherspoon St","Princeton",null,null,null,null,null,null,"Ben Davies","33 Witherspoon St","Princeton"]
[null,"Gareth Southgate","1701 Snows Mill Rd","Bogart",null,null,null,null,null,null,"Gareth Southgate","1701 Snows Mill Rd","Bogart"]
[null,"Aaron Ramsey","52 Potter Pond","Lexington",null,null,null,null,null,null,"Aaron Ramsey","52 Potter Pond","Lexington"]
[null,"Leon Bailey","905 Robertson St","Kingsport",null,null,null,null,null,null,"Leon Bailey","905 Robertson St","Kingsport"]
[null,"Scott Mctominay","1541 S Main St","Willits",null,null,null,null,null,null,"Scott Mctominay","1541 S Main St","Willits"]
[]
[null,"Name","Address",null,null,null,null,null,null,null,"Name","Address"]
[null,"Harry Maguire",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C6,D6)","v":"17640 Kentfield St, Detroit"},null,null,null,null,null,null,null,"Harry Maguire"]
[null,"Ben Davies",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,C7,D7)","v":"33 Witherspoon St, Princeton"},null,null,null,null,null,null,null,"Ben Davies"]
[null,"Gareth Southgate","1701 Snows Mill Rd, Bogart",null,null,null,null,null,null,null,"Gareth Southgate"]
[null,"Aaron Ramsey","52 Potter Pond, Lexington",null,null,null,null,null,null,null,"Aaron Ramsey"]
[null,"Leon Bailey","905 Robertson St, Kingsport",null,null,null,null,null,null,null,"Leon Bailey"]
[null,"Scott Mctominay","1541 S Main St, Willits",null,null,null,null,null,null,null,"Scott Mctominay"]

{"sheet":"Ampersand","index":3,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[1,10,1,12],[3,10,4,10],[3,11,3,12],[12,11,12,12],[13,11,13,12],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[1,1,1,3],[3,1,4,1],[3,2,3,3],[12,2,12,3],[13,2,13,3],[14,2,14,3]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Name","Address",null,null,null,null,null,null,null,"Name","Address"]
[null,null,"Street","City",null,null,null,null,null,null,null,"Street","City"]
[null,"Harry Maguire","17640 Kentfield St","Detroit",null,null,null,null,null,null,"Harry Maguire","17640 Kentfield St","Detroit"]
[null,"Ben Davies","33 Witherspoon St","Princeton",null,null,null,null,null,null,"Ben Davies","33 Witherspoon St","Princeton"]
[null,"Gareth Southgate","1701 Snows Mill Rd","Bogart",null,null,null,null,null,null,"Gareth Southgate","1701 Snows Mill Rd","Bogart"]
[null,"Aaron Ramsey","52 Potter Pond","Lexington",null,null,null,null,null,null,"Aaron Ramsey","52 Potter Pond","Lexington"]
[null,"Leon Bailey","905 Robertson St","Kingsport",null,null,null,null,null,null,"Leon Bailey","905 Robertson St","Kingsport"]
[null,"Scott Mctominay","1541 S Main St","Willits",null,null,null,null,null,null,"Scott Mctominay","1541 S Main St","Willits"]
[]
[null,"Name","Address",null,null,null,null,null,null,null,"Name","Address"]
[null,"Harry Maguire",{"$f":"C6&\", \"&D6","v":"17640 Kentfield St, Detroit"},null,null,null,null,null,null,null,"Harry Maguire"]
[null,"Ben Davies",{"$f":"C7&\", \"&D7","v":"33 Witherspoon St, Princeton"},null,null,null,null,null,null,null,"Ben Davies"]
[null,"Gareth Southgate","1701 Snows Mill Rd, Bogart",null,null,null,null,null,null,null,"Gareth Southgate"]
[null,"Aaron Ramsey","52 Potter Pond, Lexington",null,null,null,null,null,null,null,"Aaron Ramsey"]
[null,"Leon Bailey","905 Robertson St, Kingsport",null,null,null,null,null,null,null,"Leon Bailey"]
[null,"Scott Mctominay","1541 S Main St, Willits",null,null,null,null,null,null,null,"Scott Mctominay"]

{"sheet":"VBA Macro","index":4,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Incorporating VBA Macro",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Name","Street","City","Address",null,null,null,null,null,"Name","Street","City","Address"]
[null,"Harry Maguire","17640 Kentfield St","Detroit","17640 Kentfield St, Detroit",null,null,null,null,null,"Harry Maguire","17640 Kentfield St","Detroit"]
[null,"Ben Davies","33 Witherspoon St","Princeton","33 Witherspoon St, Princeton",null,null,null,null,null,"Ben Davies","33 Witherspoon St","Princeton"]
[null,"Gareth Southgate","1701 Snows Mill Rd","Bogart","1701 Snows Mill Rd, Bogart",null,null,null,null,null,"Gareth Southgate","1701 Snows Mill Rd","Bogart"]
[null,"Aaron Ramsey","52 Potter Pond","Lexington","52 Potter Pond, Lexington",null,null,null,null,null,"Aaron Ramsey","52 Potter Pond","Lexington"]
[null,"Leon Bailey","905 Robertson St","Kingsport","905 Robertson St, Kingsport",null,null,null,null,null,"Leon Bailey","905 Robertson St","Kingsport"]
[null,"Scott Mctominay","1541 S Main St","Willits","1541 S Main St, Willits",null,null,null,null,null,"Scott Mctominay","1541 S Main St","Willits"]

{"sheet":"Dataset 2","index":5,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Marks of Grade 6 Students"]
[]
[null,"Name","Math","Science"]
[null,"Peter",90,87]
[null,"Samuel",97,94]
[null,"Jonas",80,96]
[null,"Lily",66,82]

{"sheet":"One Column Over Another","index":6,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Stacking One Column Over Another",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Name","Math","Science",null,"Combined Column",null,null,null,null,"Name","Math","Science",null,"Combined Column"]
[null,"Peter",90,87,null,90,null,null,null,null,"Peter",90,87,null,{"$f":"IF(L5<>\"\",L5,INDIRECT(\"D\"&ROW()-COUNTIF(L$5:L$8,\"<>\")))","v":90}]
[null,"Samuel",97,94,null,{"$f":"IF(C6<>\"\",C6,INDIRECT(\"D\"&ROW()-COUNTIF(C$5:C$8,\"<>\")))","v":97},null,null,null,null,"Samuel",97,94,null,{"$f":"IF(L6<>\"\",L6,INDIRECT(\"D\"&ROW()-COUNTIF(L$5:L$8,\"<>\")))","v":97}]
[null,"Jonas",80,96,null,{"$f":"IF(C7<>\"\",C7,INDIRECT(\"D\"&ROW()-COUNTIF(C$5:C$8,\"<>\")))","v":80},null,null,null,null,"Jonas",80,96,null,{"$f":"IF(L7<>\"\",L7,INDIRECT(\"D\"&ROW()-COUNTIF(L$5:L$8,\"<>\")))","v":80}]
[null,"Lily",66,82,null,{"$f":"IF(C8<>\"\",C8,INDIRECT(\"D\"&ROW()-COUNTIF(C$5:C$8,\"<>\")))","v":66},null,null,null,null,"Lily",66,82,null,{"$f":"IF(L8<>\"\",L8,INDIRECT(\"D\"&ROW()-COUNTIF(L$5:L$8,\"<>\")))","v":66}]
[null,null,null,null,null,{"$f":"IF(C9<>\"\",C9,INDIRECT(\"D\"&ROW()-COUNTIF(C$5:C$8,\"<>\")))","v":87},null,null,null,null,null,null,null,null,{"$f":"IF(L9<>\"\",L9,INDIRECT(\"D\"&ROW()-COUNTIF(L$5:L$8,\"<>\")))","v":87}]
[null,null,null,null,null,{"$f":"IF(C10<>\"\",C10,INDIRECT(\"D\"&ROW()-COUNTIF(C$5:C$8,\"<>\")))","v":94},null,null,null,null,null,null,null,null,{"$f":"IF(L10<>\"\",L10,INDIRECT(\"D\"&ROW()-COUNTIF(L$5:L$8,\"<>\")))","v":94}]
[null,null,null,null,null,{"$f":"IF(C11<>\"\",C11,INDIRECT(\"D\"&ROW()-COUNTIF(C$5:C$8,\"<>\")))","v":96},null,null,null,null,null,null,null,null,{"$f":"IF(L11<>\"\",L11,INDIRECT(\"D\"&ROW()-COUNTIF(L$5:L$8,\"<>\")))","v":96}]
[null,null,null,null,null,{"$f":"IF(C12<>\"\",C12,INDIRECT(\"D\"&ROW()-COUNTIF(C$5:C$8,\"<>\")))","v":82},null,null,null,null,null,null,null,null,{"$f":"IF(L12<>\"\",L12,INDIRECT(\"D\"&ROW()-COUNTIF(L$5:L$8,\"<>\")))","v":82}]

{"sheet":"Dataset 3","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"ID Numbers of Employees of XYZ Company "]
[]
[null,"Category","Serial Number","ID Number"]
[null,"B",101155]
[null,"B",101140]
[null,"A",101139]
[null,"C",101150]
[null,"B",101141]
[null,"C",101187]
[null,"A",101193]
[null,"C",101150]

{"sheet":"Without Losing Data","index":8,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Merging Two Columns Without Losing Data",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Category","Serial Number","ID Number",null,null,null,null,null,null,"Category","Serial Number","ID Number"]
[null,"B",101155,{"$f":"_xlfn.CONCAT(B5,C5)","v":"B101155"},null,null,null,null,null,null,"B",101155]
[null,"B",101140,{"$f":"_xlfn.CONCAT(B6,C6)","v":"B101140"},null,null,null,null,null,null,"B",101140]
[null,"A",101139,"A101139",null,null,null,null,null,null,"A",101139]
[null,"C",101150,"C101150",null,null,null,null,null,null,"C",101150]
[null,"B",101141,"B101141",null,null,null,null,null,null,"B",101141]
[null,"C",101187,"C101187",null,null,null,null,null,null,"C",101187]
[null,"A",101193,"A101193",null,null,null,null,null,null,"A",101193]
[null,"C",101150,"C101150",null,null,null,null,null,null,"C",101150]