{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["dataset","CONCATENATE","CONCATENATE&CHAR","Ampersand","TEXTJOIN","Flash Fill","Text&Numeric","text&date","combine range","VBA Code","Practice"],"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","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Record of Sales of \"X\" Company"]
[]
[null,"Product","Delivery Date","State of Delivery","Sales"]
[null,"Apple","2021-01-09","Delivered",1402]
[null,"Jackfruit","2021-01-12","Delivered",5935]
[null,"Watermelon","2021-01-27","Delivered",6835]
[null,"Mango","2022-03-25","Not Delivered",7871]
[null,"Blackberry","2021-02-27","Delivered",9496]
[null,"Kiwi","2022-03-05","Not Delivered",1734]
[null,"Avocado","2021-03-10","Delivered",4662]
[null,"Tomato","2021-04-10","Delivered",3437]
[null,"Orange","2022-04-26","Not Delivered",1896]

{"sheet":"CONCATENATE","index":1,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using CONCATENATE Function"]
[]
[null,"Product","State of Delivery","Product-Delivery State"]
[null,"Apple","Delivered",{"$f":"CONCATENATE(B4,\"-\",C4)","v":"Apple-Delivered"}]
[null,"Jackfruit","Delivered",{"$f":"CONCATENATE(B5,\"-\",C5)","v":"Jackfruit-Delivered"}]
[null,"Watermelon","Delivered","Watermelon-Delivered"]
[null,"Mango","Not Delivered","Mango-Not Delivered"]
[null,"Blackberry","Delivered","Blackberry-Delivered"]
[null,"Kiwi","Not Delivered","Kiwi-Not Delivered"]
[null,"Avocado","Delivered","Avocado-Delivered"]
[null,"Tomato","Delivered","Tomato-Delivered"]
[null,"Orange","Not Delivered","Orange-Not Delivered"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CONCATENATE&CHAR","index":2,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using CONCATENATE & CHAR Function"]
[]
[null,"Product","State of Delivery","Product-Delivery State"]
[null,"Apple","Delivered",{"$f":"CONCATENATE(B4,CHAR(45),C4)","v":"Apple-Delivered"}]
[null,"Jackfruit","Delivered",{"$f":"CONCATENATE(B5,CHAR(45),C5)","v":"Jackfruit-Delivered"}]
[null,"Watermelon","Delivered","Watermelon-Delivered"]
[null,"Mango","Not Delivered","Mango-Not Delivered"]
[null,"Blackberry","Delivered","Blackberry-Delivered"]
[null,"Kiwi","Not Delivered","Kiwi-Not Delivered"]
[null,"Avocado","Delivered","Avocado-Delivered"]
[null,"Tomato","Delivered","Tomato-Delivered"]
[null,"Orange","Not Delivered","Orange-Not Delivered"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"Ampersand","index":3,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using Ampersand Operator"]
[]
[null,"Product","State of Delivery","Product-Delivery State"]
[null,"Apple","Delivered",{"$f":"B4&\"-\"&C4","v":"Apple-Delivered"}]
[null,"Jackfruit","Delivered",{"$f":"B5&\"-\"&C5","v":"Jackfruit-Delivered"}]
[null,"Watermelon","Delivered","Watermelon-Delivered"]
[null,"Mango","Not Delivered","Mango-Not Delivered"]
[null,"Blackberry","Delivered","Blackberry-Delivered"]
[null,"Kiwi","Not Delivered","Kiwi-Not Delivered"]
[null,"Avocado","Delivered","Avocado-Delivered"]
[null,"Tomato","Delivered","Tomato-Delivered"]
[null,"Orange","Not Delivered","Orange-Not Delivered"]
[]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"TEXTJOIN","index":4,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using TEXTJOIN Function"]
[]
[null,"Product","State of Delivery","Product-Delivery State"]
[null,"Apple","Delivered",{"$f":"_xlfn.TEXTJOIN(\"-\",TRUE,B4,C4)","v":"Apple-Delivered"}]
[null,"Jackfruit","Delivered",{"$f":"_xlfn.TEXTJOIN(\"-\",TRUE,B5,C5)","v":"Jackfruit-Delivered"}]
[null,"Watermelon","Delivered","Watermelon-Delivered"]
[null,"Mango","Not Delivered","Mango-Not Delivered"]
[null,"Blackberry","Delivered","Blackberry-Delivered"]
[null,"Kiwi","Not Delivered","Kiwi-Not Delivered"]
[null,"Avocado","Delivered","Avocado-Delivered"]
[null,"Tomato","Delivered","Tomato-Delivered"]
[null,"Orange","Not Delivered","Orange-Not Delivered"]
[]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"Flash Fill","index":5,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using Flash Fill Feature"]
[]
[null,"Product","State of Delivery","Product-Delivery State"]
[null,"Apple","Delivered","Apple-Delivered"]
[null,"Jackfruit","Delivered","Jackfruit-Delivered"]
[null,"Watermelon","Delivered","Watermelon-Delivered"]
[null,"Mango","Not Delivered","Mango-Not Delivered"]
[null,"Blackberry","Delivered","Blackberry-Delivered"]
[null,"Kiwi","Not Delivered","Kiwi-Not Delivered"]
[null,"Avocado","Delivered","Avocado-Delivered"]
[null,"Tomato","Delivered","Tomato-Delivered"]
[null,"Orange","Not Delivered","Orange-Not Delivered"]
[]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Text&Numeric","index":6,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Combination of Texts and Numeric Values"]
[]
[null,"Product","Sales","Product-Sales"]
[null,"Apple",1402,{"$f":"CONCATENATE(B4,CHAR(45),TEXT(C4,\"$ 0,000.00\"))","v":"Apple-$ 1,402.00"}]
[null,"Jackfruit",5935,{"$f":"CONCATENATE(B5,CHAR(45),TEXT(C5,\"$ 0,000.00\"))","v":"Jackfruit-$ 5,935.00"}]
[null,"Watermelon",6835,"Watermelon-$ 6,835.00"]
[null,"Mango",7871,"Mango-$ 7,871.00"]
[null,"Blackberry",9496,"Blackberry-$ 9,496.00"]
[null,"Kiwi",1734,"Kiwi-$ 1,734.00"]
[null,"Avocado",4662,"Avocado-$ 4,662.00"]
[null,"Tomato",3437,"Tomato-$ 3,437.00"]
[null,"Orange",1896,"Orange-$ 1,896.00"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"text&date","index":7,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Combining Texts with Dates"]
[]
[null,"Product","Delivery Date","Product-Delivery Date"]
[null,"Apple","2021-01-09",{"$f":"CONCATENATE(B4,\"-\",TEXT(C4,\"m/d/yyyy\"))","v":"Apple-1/9/2021"}]
[null,"Jackfruit","2021-01-12",{"$f":"CONCATENATE(B5,\"-\",TEXT(C5,\"m/d/yyyy\"))","v":"Jackfruit-1/12/2021"}]
[null,"Watermelon","2021-01-27","Watermelon-1/27/2021"]
[null,"Mango","2022-03-25","Mango-3/25/2022"]
[null,"Blackberry","2021-02-27","Blackberry-2/27/2021"]
[null,"Kiwi","2022-03-05","Kiwi-3/5/2022"]
[null,"Avocado","2021-03-10","Avocado-3/10/2021"]
[null,"Tomato","2021-04-10","Tomato-4/10/2021"]
[null,"Orange","2022-04-26","Orange-4/26/2022"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,""]

{"sheet":"combine range","index":8,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,2],[10,1,10,2],[11,1,11,2]]}
[null,"Combining Ranges"]
[]
[null,"Product","State of Delivery"]
[null,"Apple","Delivered"]
[null,"Jackfruit","Delivered"]
[null,"Watermelon","Delivered"]
[null,"Mango","Not Delivered"]
[null,"Blackberry","Delivered"]
[null,"Kiwi","Not Delivered"]
[]
[null,"Product-State of Delivery"]
[null,{"$f":"CONCATENATE(B4,\"-\",C4,CHAR(10),B5,\"-\",C5,CHAR(10),B6,\"-\",C6,CHAR(10),B7,\"-\",C7,CHAR(10),B8,\"-\",C8,CHAR(10),B9,\"-\",C9)","v":"Apple-Delivered\nJackfruit-Delivered\nWatermelon-Delivered\nMango-Not Delivered\nBlackberry-Delivered\nKiwi-Not Delivered"},null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,""]

{"sheet":"VBA Code","index":9,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using VBA Code"]
[]
[null,"Product","State of Delivery","Product-Delivery State"]
[null,"Apple","Delivered",{"$f":"combinecolumn(B4,C4)","v":"Apple-Delivered"}]
[null,"Jackfruit","Delivered",{"$f":"combinecolumn(B5,C5)","v":"Jackfruit-Delivered"}]
[null,"Watermelon","Delivered",{"$f":"combinecolumn(B6,C6)","v":"Watermelon-Delivered"}]
[null,"Mango","Not Delivered",{"$f":"combinecolumn(B7,C7)","v":"Mango-Not Delivered"}]
[null,"Blackberry","Delivered",{"$f":"combinecolumn(B8,C8)","v":"Blackberry-Delivered"}]
[null,"Kiwi","Not Delivered",{"$f":"combinecolumn(B9,C9)","v":"Kiwi-Not Delivered"}]
[null,"Avocado","Delivered",{"$f":"combinecolumn(B10,C10)","v":"Avocado-Delivered"}]
[null,"Tomato","Delivered",{"$f":"combinecolumn(B11,C11)","v":"Tomato-Delivered"}]
[null,"Orange","Not Delivered",{"$f":"combinecolumn(B12,C12)","v":"Orange-Not Delivered"}]
[]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"Practice","index":10,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Practice"]
[]
[null,"Product","Delivery Date","State of Delivery","Sales"]
[null,"Apple","2021-01-09","Delivered",1402]
[null,"Jackfruit","2021-01-12","Delivered",5935]
[null,"Watermelon","2021-01-27","Delivered",6835]
[null,"Mango","2022-03-25","Not Delivered",7871]
[null,"Blackberry","2021-02-27","Delivered",9496]
[null,"Kiwi","2022-03-05","Not Delivered",1734]
[null,"Avocado","2021-03-10","Delivered",4662]
[null,"Tomato","2021-04-10","Delivered",3437]
[null,"Orange","2022-04-26","Not Delivered",1896]