{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Ampersand Operator","Flash Fill","CONCAT Function","CONCATENATE Function","TEXTJOIN Function","Power Query","VBA Macros","Join Names with Comma"],"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":"Dataset","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Dataset"]
[]
[null,"First Name","Last Name"]
[null,"John","Smith"]
[null,"Andrew","Hogg"]
[null,"Adam","Paul"]
[null,"Peter","Clarke"]
[null,"Marry","Nicole"]
[null,"Harry","Tector"]
[null,"Matt","Tector"]
[null,"William","Baron"]

{"sheet":"Ampersand Operator","index":1,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"John","Smith",{"$f":"B5&\" \"&C5","v":"John Smith"},null,null,null,null,null,"John","Smith"]
[null,"Andrew","Hogg",{"$f":"B6&\" \"&C6","v":"Andrew Hogg"},null,null,null,null,null,"Andrew","Hogg"]
[null,"Adam","Paul","Adam Paul",null,null,null,null,null,"Adam","Paul"]
[null,"Peter","Clarke","Peter Clarke",null,null,null,null,null,"Peter","Clarke"]
[null,"Marry","Nicole","Marry Nicole",null,null,null,null,null,"Marry","Nicole"]
[null,"Harry","Tector","Harry Tector",null,null,null,null,null,"Harry","Tector"]
[null,"Matt","Tector","Matt Tector",null,null,null,null,null,"Matt","Tector"]
[null,"William","Baron","William Baron",null,null,null,null,null,"William","Baron"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Flash Fill","index":2,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Employing Flash Fill Feature",null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,"First Name","Last Name","Full Name"]
[null,"John","Smith","John Smith",null,null,null,null,"John","Smith"]
[null,"Andrew","Hogg","Andrew Hogg",null,null,null,null,"Andrew","Hogg"]
[null,"Adam","Paul","Adam Paul",null,null,null,null,"Adam","Paul"]
[null,"Peter","Clarke","Peter Clarke",null,null,null,null,"Peter","Clarke"]
[null,"Marry","Nicole","Marry Nicole",null,null,null,null,"Marry","Nicole"]
[null,"Harry","Tector","Harry Tector",null,null,null,null,"Harry","Tector"]
[null,"Matt","Tector","Matt Tector",null,null,null,null,"Matt","Tector"]
[null,"William","Baron","William Baron",null,null,null,null,"William","Baron"]

{"sheet":"CONCAT Function","index":3,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Utilizing CONCAT Function",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"John","Smith",{"$f":"_xlfn.CONCAT(B5,\" \",C5)","v":"John Smith"},null,null,null,null,null,"John","Smith"]
[null,"Andrew","Hogg",{"$f":"_xlfn.CONCAT(B6,\" \",C6)","v":"Andrew Hogg"},null,null,null,null,null,"Andrew","Hogg"]
[null,"Adam","Paul","Adam Paul",null,null,null,null,null,"Adam","Paul"]
[null,"Peter","Clarke","Peter Clarke",null,null,null,null,null,"Peter","Clarke"]
[null,"Marry","Nicole","Marry Nicole",null,null,null,null,null,"Marry","Nicole"]
[null,"Harry","Tector","Harry Tector",null,null,null,null,null,"Harry","Tector"]
[null,"Matt","Tector","Matt Tector",null,null,null,null,null,"Matt","Tector"]
[null,"William","Baron","William Baron",null,null,null,null,null,"William","Baron"]

{"sheet":"CONCATENATE Function","index":4,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Applying CONCATENATE Function",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"John","Smith",{"$f":"CONCATENATE(B5,\" \",C5)","v":"John Smith"},null,null,null,null,null,"John","Smith"]
[null,"Andrew","Hogg",{"$f":"CONCATENATE(B6,\" \",C6)","v":"Andrew Hogg"},null,null,null,null,null,"Andrew","Hogg"]
[null,"Adam","Paul","Adam Paul",null,null,null,null,null,"Adam","Paul"]
[null,"Peter","Clarke","Peter Clarke",null,null,null,null,null,"Peter","Clarke"]
[null,"Marry","Nicole","Marry Nicole",null,null,null,null,null,"Marry","Nicole"]
[null,"Harry","Tector","Harry Tector",null,null,null,null,null,"Harry","Tector"]
[null,"Matt","Tector","Matt Tector",null,null,null,null,null,"Matt","Tector"]
[null,"William","Baron","William Baron",null,null,null,null,null,"William","Baron"]

{"sheet":"TEXTJOIN Function","index":5,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Incorporating TEXTJOIN Function",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"John","Smith",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B5:C5)","v":"John Smith"},null,null,null,null,null,"John","Smith"]
[null,"Andrew","Hogg",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B6:C6)","v":"Andrew Hogg"},null,null,null,null,null,"Andrew","Hogg"]
[null,"Adam","Paul","Adam Paul",null,null,null,null,null,"Adam","Paul"]
[null,"Peter","Clarke","Peter Clarke",null,null,null,null,null,"Peter","Clarke"]
[null,"Marry","Nicole","Marry Nicole",null,null,null,null,null,"Marry","Nicole"]
[null,"Harry","Tector","Harry Tector",null,null,null,null,null,"Harry","Tector"]
[null,"Matt","Tector","Matt Tector",null,null,null,null,null,"Matt","Tector"]
[null,"William","Baron","William Baron",null,null,null,null,null,"William","Baron"]

{"sheet":"Power Query","index":6,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using Power Query Feature",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"John","Smith","John Smith",null,null,null,null,null,"John","Smith"]
[null,"Andrew","Hogg","Andrew Hogg",null,null,null,null,null,"Andrew","Hogg"]
[null,"Adam","Paul","Adam Paul",null,null,null,null,null,"Adam","Paul"]
[null,"Peter","Clarke","Peter Clarke",null,null,null,null,null,"Peter","Clarke"]
[null,"Marry","Nicole","Marry Nicole",null,null,null,null,null,"Marry","Nicole"]
[null,"Harry","Tector","Harry Tector",null,null,null,null,null,"Harry","Tector"]
[null,"Matt","Tector","Matt Tector",null,null,null,null,null,"Matt","Tector"]
[null,"William","Baron","William Baron",null,null,null,null,null,"William","Baron"]

{"sheet":"VBA Macros","index":7,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Applying VBA Macros",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"John","Smith","John Smith",null,null,null,null,null,"John","Smith"]
[null,"Andrew","Hogg","Andrew Hogg",null,null,null,null,null,"Andrew","Hogg"]
[null,"Adam","Paul","Adam Paul",null,null,null,null,null,"Adam","Paul"]
[null,"Peter","Clarke","Peter Clarke",null,null,null,null,null,"Peter","Clarke"]
[null,"Marry","Nicole","Marry Nicole",null,null,null,null,null,"Marry","Nicole"]
[null,"Harry","Tector","Harry Tector",null,null,null,null,null,"Harry","Tector"]
[null,"Matt","Tector","Matt Tector",null,null,null,null,null,"Matt","Tector"]
[null,"William","Baron","William Baron",null,null,null,null,null,"William","Baron"]

{"sheet":"Join Names with Comma","index":8,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Joining Names with Comma",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"John","Smith",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B5:C5)","v":"John,Smith"},null,null,null,null,null,"John","Smith"]
[null,"Andrew","Hogg",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B6:C6)","v":"Andrew,Hogg"},null,null,null,null,null,"Andrew","Hogg"]
[null,"Adam","Paul","Adam,Paul",null,null,null,null,null,"Adam","Paul"]
[null,"Peter","Clarke","Peter,Clarke",null,null,null,null,null,"Peter","Clarke"]
[null,"Marry","Nicole","Marry,Nicole",null,null,null,null,null,"Marry","Nicole"]
[null,"Harry","Tector","Harry,Tector",null,null,null,null,null,"Harry","Tector"]
[null,"Matt","Tector","Matt,Tector",null,null,null,null,null,"Matt","Tector"]
[null,"William","Baron","William,Baron",null,null,null,null,null,"William","Baron"]