{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Flash Fill","Ampersand","CONCAT","TEXTJOIN","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":"Dataset","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Name List of Students"]
[]
[null,"First Name","Last Name"]
[null,"Harry","Albert"]
[null,"Charles","Fred"]
[null,"Arthur","Henry"]
[null,"Maria","Shilutze"]
[null,"Jack","Daniel"]
[null,"Richard","Orlson"]
[null,"David","Mario"]
[null,"Howard","Anton"]
[null,"Alfred","Nobel"]
[null,"Leo","Tolostoy"]

{"sheet":"Flash Fill","index":1,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Utilizing Flash Fill Feature",null,null,null,null,"Do It Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,"First Name","Last Name","Full Name"]
[null,"Harry","Albert","Harry Albert",null,null,"Harry","Albert"]
[null,"Charles","Fred","Charles Fred",null,null,"Charles","Fred"]
[null,"Arthur","Henry","Arthur Henry",null,null,"Arthur","Henry"]
[null,"Maria","Shilutze","Maria Shilutze",null,null,"Maria","Shilutze"]
[null,"Jack","Daniel","Jack Daniel",null,null,"Jack","Daniel"]
[null,"Richard","Orlson","Richard Orlson",null,null,"Richard","Orlson"]
[null,"David","Mario","David Mario",null,null,"David","Mario"]
[null,"Howard","Anton","Howard Anton",null,null,"Howard","Anton"]
[null,"Alfred","Nobel","Alfred Nobel",null,null,"Alfred","Nobel"]
[null,"Leo","Tolostoy","Leo Tolostoy",null,null,"Leo","Tolostoy"]

{"sheet":"Ampersand","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,"Do It Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,"First Name","Last Name","Full Name"]
[null,"Harry","Albert",{"$f":"B5&\" \"&C5","v":"Harry Albert"},null,null,"Harry","Albert"]
[null,"Charles","Fred",{"$f":"B6&\" \"&C6","v":"Charles Fred"},null,null,"Charles","Fred"]
[null,"Arthur","Henry","Arthur Henry",null,null,"Arthur","Henry"]
[null,"Maria","Shilutze","Maria Shilutze",null,null,"Maria","Shilutze"]
[null,"Jack","Daniel","Jack Daniel",null,null,"Jack","Daniel"]
[null,"Richard","Orlson","Richard Orlson",null,null,"Richard","Orlson"]
[null,"David","Mario","David Mario",null,null,"David","Mario"]
[null,"Howard","Anton","Howard Anton",null,null,"Howard","Anton"]
[null,"Alfred","Nobel","Alfred Nobel",null,null,"Alfred","Nobel"]
[null,"Leo","Tolostoy","Leo Tolostoy",null,null,"Leo","Tolostoy"]

{"sheet":"CONCAT","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Implementing CONCAT Function",null,null,null,null,"Do It Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,"First Name","Last Name","Full Name"]
[null,"Harry","Albert",{"$f":"_xlfn.CONCAT(B5,\" \",C5)","v":"Harry Albert"},null,null,"Harry","Albert"]
[null,"Charles","Fred",{"$f":"_xlfn.CONCAT(B6,\" \",C6)","v":"Charles Fred"},null,null,"Charles","Fred"]
[null,"Arthur","Henry","Arthur Henry",null,null,"Arthur","Henry"]
[null,"Maria","Shilutze","Maria Shilutze",null,null,"Maria","Shilutze"]
[null,"Jack","Daniel","Jack Daniel",null,null,"Jack","Daniel"]
[null,"Richard","Orlson","Richard Orlson",null,null,"Richard","Orlson"]
[null,"David","Mario","David Mario",null,null,"David","Mario"]
[null,"Howard","Anton","Howard Anton",null,null,"Howard","Anton"]
[null,"Alfred","Nobel","Alfred Nobel",null,null,"Alfred","Nobel"]
[null,"Leo","Tolostoy","Leo Tolostoy",null,null,"Leo","Tolostoy"]

{"sheet":"TEXTJOIN","index":4,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Employing TEXTJOIN Function",null,null,null,null,"Do It Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,"First Name","Last Name","Full Name"]
[null,"Harry","Albert",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B5,C5)","v":"Harry Albert"},null,null,"Harry","Albert"]
[null,"Charles","Fred",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B6,C6)","v":"Charles Fred"},null,null,"Charles","Fred"]
[null,"Arthur","Henry","Arthur Henry",null,null,"Arthur","Henry"]
[null,"Maria","Shilutze","Maria Shilutze",null,null,"Maria","Shilutze"]
[null,"Jack","Daniel","Jack Daniel",null,null,"Jack","Daniel"]
[null,"Richard","Orlson","Richard Orlson",null,null,"Richard","Orlson"]
[null,"David","Mario","David Mario",null,null,"David","Mario"]
[null,"Howard","Anton","Howard Anton",null,null,"Howard","Anton"]
[null,"Alfred","Nobel","Alfred Nobel",null,null,"Alfred","Nobel"]
[null,"Leo","Tolostoy","Leo Tolostoy",null,null,"Leo","Tolostoy"]

{"sheet":"Power Query","index":5,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Executing Power Query",null,null,null,null,"Do It Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,"First Name","Last Name","Full Name"]
[null,"Harry","Albert","Harry Albert",null,null,"Harry","Albert"]
[null,"Charles","Fred","Charles Fred",null,null,"Charles","Fred"]
[null,"Arthur","Henry","Arthur Henry",null,null,"Arthur","Henry"]
[null,"Maria","Shilutze","Maria Shilutze",null,null,"Maria","Shilutze"]
[null,"Jack","Daniel","Jack Daniel",null,null,"Jack","Daniel"]
[null,"Richard","Orlson","Richard Orlson",null,null,"Richard","Orlson"]
[null,"David","Mario","David Mario",null,null,"David","Mario"]
[null,"Howard","Anton","Howard Anton",null,null,"Howard","Anton"]
[null,"Alfred","Nobel","Alfred Nobel",null,null,"Alfred","Nobel"]
[null,"Leo","Tolostoy","Leo Tolostoy",null,null,"Leo","Tolostoy"]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Assigning VBA Code",null,null,null,null,"Do It Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,"First Name","Last Name","Full Name"]
[null,"Harry","Albert",{"$f":"Rvrs_Txt_Clmn(B5:C5,\" \")","v":"Harry Albert"},null,null,"Harry","Albert"]
[null,"Charles","Fred",{"$f":"Rvrs_Txt_Clmn(B6:C6,\" \")","v":"Charles Fred"},null,null,"Charles","Fred"]
[null,"Arthur","Henry",{"$f":"Rvrs_Txt_Clmn(B7:C7,\" \")","v":"Arthur Henry"},null,null,"Arthur","Henry"]
[null,"Maria","Shilutze",{"$f":"Rvrs_Txt_Clmn(B8:C8,\" \")","v":"Maria Shilutze"},null,null,"Maria","Shilutze"]
[null,"Jack","Daniel",{"$f":"Rvrs_Txt_Clmn(B9:C9,\" \")","v":"Jack Daniel"},null,null,"Jack","Daniel"]
[null,"Richard","Orlson",{"$f":"Rvrs_Txt_Clmn(B10:C10,\" \")","v":"Richard Orlson"},null,null,"Richard","Orlson"]
[null,"David","Mario",{"$f":"Rvrs_Txt_Clmn(B11:C11,\" \")","v":"David Mario"},null,null,"David","Mario"]
[null,"Howard","Anton",{"$f":"Rvrs_Txt_Clmn(B12:C12,\" \")","v":"Howard Anton"},null,null,"Howard","Anton"]
[null,"Alfred","Nobel",{"$f":"Rvrs_Txt_Clmn(B13:C13,\" \")","v":"Alfred Nobel"},null,null,"Alfred","Nobel"]
[null,"Leo","Tolostoy",{"$f":"Rvrs_Txt_Clmn(B14:C14,\" \")","v":"Leo Tolostoy"},null,null,"Leo","Tolostoy"]