{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["&","&_IF","CONCATENATE","CONCAT","TRANSPOSE","TEXTJOIN","IF_TEXTJOIN","OFFSET","Fill","Table5","Power_Query","VBA"],"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":"&","index":0,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of Ampersand (&) Operator",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Text in Rows","Concatenated Text",null,null,null,null,null,null,null,null,"Text in Rows","Concatenated Test"]
[null,"Sun",{"$f":"B5&\" \"&B6&\" \"&B7&\" \"&B8&\" \"&B9","v":"Sun rises in the east"},null,null,null,null,null,null,null,null,"Sun"]
[null,"rises",null,null,null,null,null,null,null,null,null,"rises"]
[null,"in",null,null,null,null,null,null,null,null,null,"in"]
[null,"the",null,null,null,null,null,null,null,null,null,"the"]
[null,"east",null,null,null,null,null,null,null,null,null,"east"]

{"sheet":"&_IF","index":1,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,9,1,12],[1,1,1,4]]}
[]
[null,"Apmersand (&) Operator and IF Function",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits Type","Fruit Name","Concatenated Text","Check",null,null,null,null,"Fruits Type","Fruit Name","Concatenated Text","Check"]
[null,"Citrus Fruits","Lemon",{"$f":"IF(B5=B4,D4&\",\"&C5,C5)","v":"Lemon"},{"$f":"IF(B5<>B6,\"Last\",\"\")","v":""},null,null,null,null,"Citrus Fruits","Lemon"]
[null,"Citrus Fruits","Orange",{"$f":"IF(B6=B5,D5&\",\"&C6,C6)","v":"Lemon,Orange"},{"$f":"IF(B6<>B7,\"Last\",\"\")","v":""},null,null,null,null,"Citrus Fruits","Orange"]
[null,"Citrus Fruits","Lime","Lemon,Orange,Lime","Last",null,null,null,null,"Citrus Fruits","Lime"]
[null,"Dry Fruits","Dates","Dates","",null,null,null,null,"Dry Fruits","Dates"]
[null,"Dry Fruits","Raisins","Dates,Raisins","",null,null,null,null,"Dry Fruits","Raisins"]
[null,"Dry Fruits","Apricots","Dates,Raisins,Apricots","Last",null,null,null,null,"Dry Fruits","Apricots"]

{"sheet":"CONCATENATE","index":2,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of CONCATENATE Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Text in Rows","Concatenated Text",null,null,null,null,null,null,null,null,"Text in Rows","Concatenated Text"]
[null,"Sun",{"$f":"CONCATENATE(B5,\" \",B6,\" \",B7,\" \",B8,\" \",B9)","v":"Sun rises in the east"},null,null,null,null,null,null,null,null,"Sun",{"$f":"CONCATENATE(L5,\" \",L6,\" \",L7,\" \",L8,\" \",L9)","v":"Sun rises in the east"}]
[null,"rises",null,null,null,null,null,null,null,null,null,"rises"]
[null,"in",null,null,null,null,null,null,null,null,null,"in"]
[null,"the",null,null,null,null,null,null,null,null,null,"the"]
[null,"east",null,null,null,null,null,null,null,null,null,"east"]

{"sheet":"CONCAT","index":3,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of CONCAT Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Text in Rows","Concatenated Text",null,null,null,null,null,null,null,null,"Text in Rows","Concatenated Text"]
[null,221,{"$f":"_xlfn.CONCAT(B5:B7)","v":"221BakerStreet"},null,null,null,null,null,null,null,null,221,{"$f":"_xlfn.CONCAT(L5:L7)","v":"221BakerStreet"}]
[null,"Baker",null,null,null,null,null,null,null,null,null,"Baker"]
[null,"Street",null,null,null,null,null,null,null,null,null,"Street"]

{"sheet":"TRANSPOSE","index":4,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"TRANSPOSE & CONCATENATE Functions",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Text in Rows","Concatenated Text",null,null,null,null,null,null,null,null,"Text in Rows","Concatenated Text"]
[null,221,{"$f":"CONCATENATE(221,\"Baker\",\"Street\")","v":"221BakerStreet"},null,null,null,null,null,null,null,null,221,{"$f":"CONCATENATE(221,\"Baker\",\"Street\")","v":"221BakerStreet"}]
[null,"Baker",null,null,null,null,null,null,null,null,null,"Baker"]
[null,"Street",null,null,null,null,null,null,null,null,null,"Street"]

{"sheet":"TEXTJOIN","index":5,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of TEXTJOIN Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Text in Rows","Concatenated Text",null,null,null,null,null,null,null,null,"Text in Rows","Concatenated Text"]
[null,"Sun",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B5:B9)","v":"Sun rises in the east"},null,null,null,null,null,null,null,null,"Sun",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,L5:L9)","v":"Sun rises in the east"}]
[null,"rises",null,null,null,null,null,null,null,null,null,"rises"]
[null,"in",null,null,null,null,null,null,null,null,null,"in"]
[null,"the",null,null,null,null,null,null,null,null,null,"the"]
[null,"east",null,null,null,null,null,null,null,null,null,"east"]

{"sheet":"IF_TEXTJOIN","index":6,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"TEXTJOIN & IF Functions",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits Type","Fruit Name","Concatenated Text",null,null,null,null,null,null,null,"Fruits Type","Fruit Name","Concatenated Text"]
[null,"Citrus Fruits","Lemon",{"$f":"IF(B5=\"\",\"\",_xlfn.TEXTJOIN(\", \",TRUE,C5:C7))","v":"Lemon, Orange, Lime"},null,null,null,null,null,null,null,"Citrus Fruits","Lemon"]
[null,null,"Orange",{"$f":"IF(B6=\"\",\"\",_xlfn.TEXTJOIN(\", \",TRUE,C6:C8))","v":""},null,null,null,null,null,null,null,null,"Orange"]
[null,null,"Lime","",null,null,null,null,null,null,null,null,"Lime"]
[null,"Dry Fruits","Dates","Dates, Raisins, Apricots",null,null,null,null,null,null,null,"Dry Fruits","Dates"]
[null,null,"Raisins","",null,null,null,null,null,null,null,null,"Raisins"]
[null,null,"Apricots",{"$f":"IF(B10=\"\",\"\",_xlfn.TEXTJOIN(\", \",TRUE,C10:C12))","v":""},null,null,null,null,null,null,null,null,"Apricots"]

{"sheet":"OFFSET","index":7,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"TEXTJOIN, OFFSET, COUNTIF & IF Functions",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruit Type","Fruit Name","Concatenated Text",null,null,null,null,null,null,null,"Fruit Type","Fruit Name","Concatenated Text"]
[null,"Citrus Fruits","Lemon",{"$f":"IF(B5=B4,\"\",_xlfn.TEXTJOIN(\", \",TRUE,OFFSET(C5,0,0,\nCOUNTIF(B:B,B5),1)))","v":"Lemon, Orange, Lime"},null,null,null,null,null,null,null,"Citrus Fruits","Lemon"]
[null,"Citrus Fruits","Orange",{"$f":"IF(B6=B5,\"\",_xlfn.TEXTJOIN(\", \",TRUE,OFFSET(C6,0,0,\nCOUNTIF(B:B,B6),1)))","v":""},null,null,null,null,null,null,null,"Citrus Fruits","Orange"]
[null,"Citrus Fruits","Lime","",null,null,null,null,null,null,null,"Citrus Fruits","Lime"]
[null,"Dry Fruits","Dates","Dates, Raisins, Apricots",null,null,null,null,null,null,null,"Dry Fruits","Dates"]
[null,"Dry Fruits","Raisins","",null,null,null,null,null,null,null,"Dry Fruits","Raisins"]
[null,"Dry Fruits","Apricots","",null,null,null,null,null,null,null,"Dry Fruits","Apricots"]

{"sheet":"Fill","index":8,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Fill Justify Option"]
[]
[null,"Text in Rows"]
[null,"Sun rises in the east"]

{"sheet":"Table5","index":9,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Concatenated"]
["Sun rises in the east"]

{"sheet":"Power_Query","index":10,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Power Query"]
[]
[null,"Text in Rows"]
[null,"Sun"]
[null,"rises"]
[null,"in"]
[null,"the"]
[null,"east"]

{"sheet":"VBA","index":11,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA"]
[]
[null,"Text in Rows","Concatenated Text"]
[null,"Sun","Sun rises in the east"]
[null,"rises"]
[null,"in"]
[null,"the"]
[null,"east"]