{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Applying Consolidate Feature","Applying Consolidate Feature(2)","Applying Consolidate Feature(3)","Applying Consolidate Feature(4)","Using Ampersand(&) Operator","Using CONCATENATE Function","Applying TEXTJOIN Function","Use of Notepad","Using VBA"],"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":"Applying Consolidate Feature","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying Consolidate Feature"]
[]
[null,"Name","Purchases"]
[null,"Jack",40]
[null,"Emma",100]
[null,"William",29]
[null,"Rose",75]
[null,"Harry",120]
[null,"Ron",88]
[null,"Billy",34]
[null,"Mary",56]
[null,"Patricia",80]
[null,"James",30]

{"sheet":"Applying Consolidate Feature(2)","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying Consolidate Feature"]
[]
[null,"Name","Purchases"]
[null,"Jack",67]
[null,"Emma",50]
[null,"William",56]
[null,"Rose",107]
[null,"Harry",23]
[null,"Ron",55]
[null,"Billy",78]
[null,"Mary",60]
[null,"Patricia",95]
[null,"James",75]

{"sheet":"Applying Consolidate Feature(3)","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying Consolidate Feature"]
[]
[null,"Name","Purchases"]
[null,"Jack",98]
[null,"Emma",40]
[null,"William",75]
[null,"Rose",56]
[null,"Harry",30]
[null,"Ron",44]
[null,"Billy",63]
[null,"Mary",50]
[null,"Patricia",35]
[null,"James",80]

{"sheet":"Applying Consolidate Feature(4)","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Applying Consolidate Feature",null,null,null,null,"Do It YourSelf"]
[]
[null,"Name","Purchases",null,null,null,"Name","Purchases"]
[null,"Jack",205,null,null,null,"Jack"]
[null,"Emma",190,null,null,null,"Emma"]
[null,"William",160,null,null,null,"William"]
[null,"Rose",238,null,null,null,"Rose"]
[null,"Harry",173,null,null,null,"Harry"]
[null,"Ron",187,null,null,null,"Ron"]
[null,"Billy",175,null,null,null,"Billy"]
[null,"Mary",166,null,null,null,"Mary"]
[null,"Patricia",210,null,null,null,"Patricia"]
[null,"James",185,null,null,null,"James"]

{"sheet":"Using Ampersand(&) Operator","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,"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,"Jack","Smith",{"$f":"B5&\" \"& C5","v":"Jack Smith"},null,null,"Jack","Smith"]
[null,"Emma","Wilson",{"$f":"B6&\" \"& C6","v":"Emma Wilson"},null,null,"Emma","Wilson"]
[null,"William","Miller","William Miller",null,null,"William","Miller"]
[null,"Rose","Brown","Rose Brown",null,null,"Rose","Brown"]
[null,"Harry","Anderson","Harry Anderson",null,null,"Harry","Anderson"]
[null,"Ron","Garcia","Ron Garcia",null,null,"Ron","Garcia"]
[null,"Billy","Martinez","Billy Martinez",null,null,"Billy","Martinez"]
[null,"Mary","White","Mary White",null,null,"Mary","White"]
[null,"Patricia","Clark","Patricia Clark",null,null,"Patricia","Clark"]
[null,"James","Lewis","James Lewis",null,null,"James","Lewis"]

{"sheet":"Using CONCATENATE Function","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,"Use of CONCAT or CONCATENATE Function",null,null,null,null,"Do It YourSelf"]
[]
[null,"First Name","Last Name","Full Name",null,null,"First Name","Last Name","Full Name"]
[null,"Jack","Smith",{"$f":"CONCATENATE(B5,\" \",C5)","v":"Jack Smith"},null,null,"Jack","Smith"]
[null,"Emma","Wilson",{"$f":"CONCATENATE(B6,\" \",C6)","v":"Emma Wilson"},null,null,"Emma","Wilson"]
[null,"William","Miller","William Miller",null,null,"William","Miller"]
[null,"Rose","Brown","Rose Brown",null,null,"Rose","Brown"]
[null,"Harry","Anderson","Harry Anderson",null,null,"Harry","Anderson"]
[null,"Ron","Garcia","Ron Garcia",null,null,"Ron","Garcia"]
[null,"Billy","Martinez","Billy Martinez",null,null,"Billy","Martinez"]
[null,"Mary","White","Mary White",null,null,"Mary","White"]
[null,"Patricia","Clark","Patricia Clark",null,null,"Patricia","Clark"]
[null,"James","Lewis","James Lewis",null,null,"James","Lewis"]

{"sheet":"Applying TEXTJOIN Function","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,"Applying 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,"Jack","Smith",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B5,C5)","v":"Jack Smith"},null,null,"Jack","Smith"]
[null,"Emma","Wilson",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B6,C6)","v":"Emma Wilson"},null,null,"Emma","Wilson"]
[null,"William","Miller","William Miller",null,null,"William","Miller"]
[null,"Rose","Brown","Rose Brown",null,null,"Rose","Brown"]
[null,"Harry","Anderson","Harry Anderson",null,null,"Harry","Anderson"]
[null,"Ron","Garcia","Ron Garcia",null,null,"Ron","Garcia"]
[null,"Billy","Martinez","Billy Martinez",null,null,"Billy","Martinez"]
[null,"Mary","White","Mary White",null,null,"Mary","White"]
[null,"Patricia","Clark","Patricia Clark",null,null,"Patricia","Clark"]
[null,"James","Lewis","James Lewis",null,null,"James","Lewis"]

{"sheet":"Use of Notepad","index":7,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of Notepad",null,null,null,null,"Do It YourSelf"]
[]
[null,"First Name","Last Name","Full Name",null,null,"First Name","Last Name","Full Name"]
[null,"Jack","Smith","Jack Smith",null,null,"Jack","Smith"]
[null,"Emma","Wilson","Emma Wilson",null,null,"Emma","Wilson"]
[null,"William","Miller","William Miller",null,null,"William","Miller"]
[null,"Rose","Brown","Rose Brown",null,null,"Rose","Brown"]
[null,"Harry","Anderson","Harry Anderson",null,null,"Harry","Anderson"]
[null,"Ron","Garcia","Ron Garcia",null,null,"Ron","Garcia"]
[null,"Billy","Martinez","Billy Martinez",null,null,"Billy","Martinez"]
[null,"Mary","White","Mary White",null,null,"Mary","White"]
[null,"Patricia","Clark","Patricia Clark",null,null,"Patricia","Clark"]
[null,"James","Lewis","James Lewis",null,null,"James","Lewis"]

{"sheet":"Using VBA","index":8,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,11]]}
[]
[null,"Using VBA",null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"First Name","Jack","Emma","Rose",null,null,null,null,"Jack","Emma","Rose"]
[null,"Last Name","Smith","Wilson","Brown",null,null,null,null,"Smith","Wilson","Brown"]
[null,"State","Texas","Ohio","Florida",null,null,null,null,"Texas","Ohio","Florida"]
[]
[null,"Combined Columns"]