{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Ampersand","CONCAT","CONCATENATE and TRANSPOSE ","TEXTJOIN","Formula Bar","VBA Macro","New Line"],"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":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[" "]
[null,"List of Favorite Fruits of Employees"]
[]
[null,"Name","Favorite Fruits"]
[null,"James","Grape"]
[null,"Victor","Apple"]
[null,"Alekxander","Orange"]
[null,"Rose","Cherry"]
[null,"Jim","Blueberries"]
[null,"Steve","Banana"]
[null,"Jerry","Lichi"]
[null,"Rodney","Mango"]
[null,"Alan","Strawberry"]
[null,"Penny","Pineapple"]
[null,"Harry","Blackberry"]
[null,"Lily","Guava"]

{"sheet":"Ampersand","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,7,3],[8,3,11,3],[12,3,15,3],[1,7,1,9],[4,9,7,9],[8,9,11,9],[12,9,15,9]]}
[" "]
[null,"Using Ampersand Operator",null,null,null,null,null,"Practice section"]
[]
[null,"Name","Favorite Fruits","Multiple Rows in One Cell",null,null,null,"Name","Favorite Fruits","Multiple Rows in One Cell"]
[null,"James","Grape",{"$f":"C5&\",\"&C6&\",\"&C7&\",\"&C8","v":"Grape,Apple,Orange,Cherry"},null,null,null,"James","Grape"]
[null,"Victor","Apple",null,null,null,null,"Victor","Apple"]
[null,"Alekxander","Orange",null,null,null,null,"Alekxander","Orange"]
[null,"Rose","Cherry",null,null,null,null,"Rose","Cherry"]
[null,"Jim","Blueberries",{"$f":"C9&\",\"&C10&\",\"&C11&\",\"&C12","v":"Blueberries,Banana,Lichi,Mango"},null,null,null,"Jim","Blueberries"]
[null,"Steve","Banana",null,null,null,null,"Steve","Banana"]
[null,"Jerry","Lichi",null,null,null,null,"Jerry","Lichi"]
[null,"Rodney","Mango",null,null,null,null,"Rodney","Mango"]
[null,"Alan","Strawberry",{"$f":"C13&\",\"&C14&\",\"&C15&\",\"&C16","v":"Strawberry,Pineapple,Blackberry,Guava"},null,null,null,"Alan","Strawberry"]
[null,"Penny","Pineapple",null,null,null,null,"Penny","Pineapple"]
[null,"Harry","Blackberry",null,null,null,null,"Harry","Blackberry"]
[null,"Lily","Guava",null,null,null,null,"Lily","Guava"]

{"sheet":"CONCAT","index":2,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,7,3],[8,3,11,3],[12,3,15,3],[1,8,1,10],[4,10,7,10],[8,10,11,10],[12,10,15,10]]}
[" "]
[null,"Applying CONCAT Function",null,null,null,null,null,null,"Practice section"]
[]
[null,"Name","Favorite Fruits","Multiple Rows in One Cell",null,null,null,null,"Name","Favorite Fruits","Multiple Rows in One Cell"]
[null,"James","Grape",{"$f":"_xlfn.CONCAT(C5,\", \",C6,\", \",C7,\" and \",C8)","v":"Grape, Apple, Orange and Cherry"},null,null,null,null,"James","Grape"]
[null,"Victor","Apple",null,null,null,null,null,"Victor","Apple"]
[null,"Alekxander","Orange",null,null,null,null,null,"Alekxander","Orange"]
[null,"Rose","Cherry",null,null,null,null,null,"Rose","Cherry"]
[null,"Jim","Blueberries",{"$f":"_xlfn.CONCAT(C9,\", \",C10,\", \",C11,\" and \",C12)","v":"Blueberries, Banana, Lichi and Mango"},null,null,null,null,"Jim","Blueberries"]
[null,"Steve","Banana",null,null,null,null,null,"Steve","Banana"]
[null,"Jerry","Lichi",null,null,null,null,null,"Jerry","Lichi"]
[null,"Rodney","Mango",null,null,null,null,null,"Rodney","Mango"]
[null,"Alan","Strawberry",{"$f":"_xlfn.CONCAT(C13,\", \",C14,\", \",C15,\" and \",C16)","v":"Strawberry, Pineapple, Blackberry and Guava"},null,null,null,null,"Alan","Strawberry"]
[null,"Penny","Pineapple",null,null,null,null,null,"Penny","Pineapple"]
[null,"Harry","Blackberry",null,null,null,null,null,"Harry","Blackberry"]
[null,"Lily","Guava",null,null,null,null,null,"Lily","Guava"]

{"sheet":"CONCATENATE and TRANSPOSE ","index":3,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,7,3],[8,3,11,3],[12,3,15,3],[1,8,1,10],[4,10,7,10],[8,10,11,10],[12,10,15,10]]}
[" "]
[null,"Utilizing CONCATENATE and TRANSPOSE Functions",null,null,null,null,null,null,"Practice section"]
[]
[null,"Name","Favorite Fruits","Multiple Rows in One Cell",null,null,null,null,"Name","Favorite Fruits","Multiple Rows in One Cell"]
[null,"James","Grape",{"$f":"CONCATENATE(\"Grape\",\",\",\"Apple\",\",\",\"Orange\",\" and \",\"Cherry\")","v":"Grape,Apple,Orange and Cherry"},null,null,null,null,"James","Grape"]
[null,"Victor","Apple",null,null,null,null,null,"Victor","Apple"]
[null,"Alekxander","Orange",null,null,null,null,null,"Alekxander","Orange"]
[null,"Rose","Cherry",null,null,null,null,null,"Rose","Cherry"]
[null,"Jim","Blueberries",{"$f":"CONCATENATE(\"Blueberries\",\",\",\"Banana\",\",\",\"Lichi\",\" and \",\"Mango\")","v":"Blueberries,Banana,Lichi and Mango"},null,null,null,null,"Jim","Blueberries"]
[null,"Steve","Banana",null,null,null,null,null,"Steve","Banana"]
[null,"Jerry","Lichi",null,null,null,null,null,"Jerry","Lichi"]
[null,"Rodney","Mango",null,null,null,null,null,"Rodney","Mango"]
[null,"Alan","Strawberry",{"$f":"CONCATENATE(\"Strawberry\",\",\",\"Pineapple\",\",\",\"Blackberry\",\" and \",\"Guava\")","v":"Strawberry,Pineapple,Blackberry and Guava"},null,null,null,null,"Alan","Strawberry"]
[null,"Penny","Pineapple",null,null,null,null,null,"Penny","Pineapple"]
[null,"Harry","Blackberry",null,null,null,null,null,"Harry","Blackberry"]
[null,"Lily","Guava",null,null,null,null,null,"Lily","Guava"]

{"sheet":"TEXTJOIN","index":4,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,7,3],[8,3,11,3],[12,3,15,3],[1,8,1,10],[4,10,7,10],[8,10,11,10],[12,10,15,10]]}
[" "]
[null,"Implementing TEXTJOIN Function",null,null,null,null,null,null,"Practice section"]
[]
[null,"Name","Favorite Fruits","Multiple Rows in One Cell",null,null,null,null,"Name","Favorite Fruits","Multiple Rows in One Cell"]
[null,"James","Grape",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B5:B8)","v":"James,Victor,Alekxander,Rose"},null,null,null,null,"James","Grape"]
[null,"Victor","Apple",null,null,null,null,null,"Victor","Apple"]
[null,"Alekxander","Orange",null,null,null,null,null,"Alekxander","Orange"]
[null,"Rose","Cherry",null,null,null,null,null,"Rose","Cherry"]
[null,"Jim","Blueberries",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B9:B12)","v":"Jim,Steve,Jerry,Rodney"},null,null,null,null,"Jim","Blueberries"]
[null,"Steve","Banana",null,null,null,null,null,"Steve","Banana"]
[null,"Jerry","Lichi",null,null,null,null,null,"Jerry","Lichi"]
[null,"Rodney","Mango",null,null,null,null,null,"Rodney","Mango"]
[null,"Alan","Strawberry",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B13:B16)","v":"Alan,Penny,Harry,Lily"},null,null,null,null,"Alan","Strawberry"]
[null,"Penny","Pineapple",null,null,null,null,null,"Penny","Pineapple"]
[null,"Harry","Blackberry",null,null,null,null,null,"Harry","Blackberry"]
[null,"Lily","Guava",null,null,null,null,null,"Lily","Guava"]

{"sheet":"Formula Bar","index":5,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,7,3],[8,3,11,3],[12,3,15,3],[1,8,1,10],[4,10,7,10],[8,10,11,10],[12,10,15,10]]}
[" "]
[null,"Employing Formula Bar",null,null,null,null,null,null,"Practice section"]
[]
[null,"Name","Favorite Fruits","Multiple Rows in One Cell",null,null,null,null,"Name","Favorite Fruits","Multiple Rows in One Cell"]
[null,"James","Grape","Ahmed \nVictor\nAlekxander\nRose",null,null,null,null,"James","Grape"]
[null,"Victor","Apple",null,null,null,null,null,"Victor","Apple"]
[null,"Alekxander","Orange",null,null,null,null,null,"Alekxander","Orange"]
[null,"Rose","Cherry",null,null,null,null,null,"Rose","Cherry"]
[null,"Jim","Blueberries","Jim\nSteve\nJerry\nRodney",null,null,null,null,"Jim","Blueberries"]
[null,"Steve","Banana",null,null,null,null,null,"Steve","Banana"]
[null,"Jerry","Lichi",null,null,null,null,null,"Jerry","Lichi"]
[null,"Rodney","Mango",null,null,null,null,null,"Rodney","Mango"]
[null,"Alan","Strawberry","Alan\nPenny\nHarry\nLily",null,null,null,null,"Alan","Strawberry"]
[null,"Penny","Pineapple",null,null,null,null,null,"Penny","Pineapple"]
[null,"Harry","Blackberry",null,null,null,null,null,"Harry","Blackberry"]
[null,"Lily","Guava",null,null,null,null,null,"Lily","Guava"]

{"sheet":"VBA Macro","index":6,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,7,3],[8,3,11,3],[12,3,15,3],[1,9,1,11],[4,11,7,11],[8,11,11,11],[12,11,15,11]]}
[" "]
[null,"Incorporating VBA Macro",null,null,null,null,null,null,null,"Practice section"]
[]
[null,"Name","Favorite Fruits","Multiple Rows in One Cell",null,null,null,null,null,"Name","Favorite Fruits","Multiple Rows in One Cell"]
[null,"James","Grape"," Grape Apple Orange Cherry",null,null,null,null,null,"James","Grape"]
[null,"Victor","Apple",null,null,null,null,null,null,"Victor","Apple"]
[null,"Alekxander","Orange",null,null,null,null,null,null,"Alekxander","Orange"]
[null,"Rose","Cherry",null,null,null,null,null,null,"Rose","Cherry"]
[null,"Jim","Blueberries"," Blueberries Banana Lichi Mango",null,null,null,null,null,"Jim","Blueberries"]
[null,"Steve","Banana",null,null,null,null,null,null,"Steve","Banana"]
[null,"Jerry","Lichi",null,null,null,null,null,null,"Jerry","Lichi"]
[null,"Rodney","Mango",null,null,null,null,null,null,"Rodney","Mango"]
[null,"Alan","Strawberry"," Strawberry Pineapple Blackberry Guava",null,null,null,null,null,"Alan","Strawberry"]
[null,"Penny","Pineapple",null,null,null,null,null,null,"Penny","Pineapple"]
[null,"Harry","Blackberry",null,null,null,null,null,null,"Harry","Blackberry"]
[null,"Lily","Guava",null,null,null,null,null,null,"Lily","Guava"]

{"sheet":"New Line","index":7,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,7,3],[8,3,11,3],[12,3,15,3],[1,8,1,10],[4,10,7,10],[8,10,11,10],[12,10,15,10]]}
[" "]
[null,"Inserting New Line Within a Cell",null,null,null,null,null,null,"Practice section"]
[]
[null,"Name","Favorite Fruits","Multiple Lines in One Cell",null,null,null,null,"Name","Favorite Fruits","Multiple Rows in One Cell"]
[null,"James","Grape","Grape\nApple\nOrange\nCherry",null,null,null,null,"James","Grape"]
[null,"Victor","Apple",null,null,null,null,null,"Victor","Apple"]
[null,"Alekxander","Orange",null,null,null,null,null,"Alekxander","Orange"]
[null,"Rose","Cherry",null,null,null,null,null,"Rose","Cherry"]
[null,"Jim","Blueberries","Blueberries\nBanana\nLichi\nMango",null,null,null,null,"Jim","Blueberries"]
[null,"Steve","Banana",null,null,null,null,null,"Steve","Banana"]
[null,"Jerry","Lichi",null,null,null,null,null,"Jerry","Lichi"]
[null,"Rodney","Mango",null,null,null,null,null,"Rodney","Mango"]
[null,"Alan","Strawberry","Strawberry\nPineapple\nBlackberry\nGuava",null,null,null,null,"Alan","Strawberry"]
[null,"Penny","Pineapple",null,null,null,null,null,"Penny","Pineapple"]
[null,"Harry","Blackberry",null,null,null,null,null,"Harry","Blackberry"]
[null,"Lily","Guava",null,null,null,null,null,"Lily","Guava"]