{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["February","January","Consolidate","Name","Department","Combined","Name-1","Department-1","Query1","PowerQuery","Name (2)","Department (2)","VLOOKUP"],"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":"February","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Consolidate Rows"]
[]
[null,"Salesperson","February"]
[null,"John",2000]
[null,"Chris",2400]
[null,"Tony Lisa",2700]
[null,"Evan",1800]

{"sheet":"January","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Consolidate Rows"]
[]
[null,"Salesperson","January"]
[null,"John",2500]
[null,"Chris",2700]
[null,"Tony Lisa",2950]
[null,"Evan",2300]

{"sheet":"Consolidate","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Consolidate Rows"]
[]
[null,"Salesperson","January","February"]
[null,"John",2500,2000]
[null,"Chris",2700,2400]
[null,"Tony Lisa",2950,2700]
[null,"Evan",2300,1800]

{"sheet":"Name","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Employee ID","Full Name"]
[null,"JB-008","John Doe"]
[null,"DY-006","Aron Donnel"]
[null,"TW-022","Ella Marshal"]
[null,"AY-007","Eric Thomson"]

{"sheet":"Department","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Employee ID","Department"]
[null,"JB-008","Sales"]
[null,"DY-006","Accounts"]
[null,"TW-022","Human Resource"]
[null,"AY-007","Logistic"]

{"sheet":"Combined","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Employee ID","Department"]
["JB-008","John Doe"]
["DY-006","Aron Donnel"]
["TW-022","Ella Marshal"]
["AY-007","Eric Thomson"]
["JB-008","Sales"]
["DY-006","Accounts"]
["TW-022","Human Resource"]
["AY-007","Logistic"]

{"sheet":"Name-1","index":6,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Power Query"]
[]
[null,"Employee ID","Full Name"]
[null,"JB-008","John Doe"]
[null,"DY-006","Aron Donnel"]
[null,"TW-022","Ella Marshal"]
[null,"AY-007","Eric Thomson"]

{"sheet":"Department-1","index":7,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Power Query"]
[]
[null,"Employee ID","Full Name"]
[null,"XB-003","Avery Denvers"]
[null,"AY-011","Hardy Miller"]
[null,"DW-033","Russel Wahlberg"]
[null,"ER-022","Kyla Wood"]

{"sheet":"Query1","index":8,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Employee ID","Full Name","Name"]
["JB-008","John Doe","Group_1"]
["DY-006","Aron Donnel","Group_1"]
["TW-022","Ella Marshal","Group_1"]
["AY-007","Eric Thomson","Group_1"]
["XB-003","Avery Denvers","Group_2"]
["AY-011","Hardy Miller","Group_2"]
["DW-033","Russel Wahlberg","Group_2"]
["ER-022","Kyla Wood","Group_2"]

{"sheet":"PowerQuery","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Name (2)","index":10,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combination of IFERROR & VLOOKUP Functions"]
[]
[null,"Employee ID","Full Name","Department"]
[null,"JB-008","John Doe","Sales"]
[null,"DY-006","Aron Donnel","Accounts"]

{"sheet":"Department (2)","index":11,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combination of IFERROR & VLOOKUP Functions"]
[]
[null,"Employee ID","Full Name","Department"]
[null,"TW-022","Ella Marshal","Human Resource"]
[null,"AY-007","Eric Thomson","Logistic"]

{"sheet":"VLOOKUP","index":12,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combination of IFERROR & VLOOKUP Functions"]
[]
[null,"Employee ID","Full Name","Department"]
[null,"JB-008",{"$f":"IFERROR(VLOOKUP(B5,'Name (2)'!B5:D6,2),\"Not Found\")","v":"John Doe"},{"$f":"IFERROR(VLOOKUP(C5,'Name (2)'!C5:E6,2),\"Not Found\")","v":"Sales"}]
[null,"DY-006",{"$f":"IFERROR(VLOOKUP(B6,'Name (2)'!B6:D7,2),\"Not Found\")","v":"Aron Donnel"},{"$f":"IFERROR(VLOOKUP(C6,'Name (2)'!C6:E7,2),\"Not Found\")","v":"Accounts"}]
[null,"TW-022",{"$f":"IFERROR(VLOOKUP(B7,'Department (2)'!B5:D6,2,FALSE),\"Not Found\")","v":"Ella Marshal"},{"$f":"IFERROR(VLOOKUP(C7,'Department (2)'!C5:E6,2,FALSE),\"Not Found\")","v":"Human Resource"}]
[null,"AY-007",{"$f":"IFERROR(VLOOKUP(B8,'Department (2)'!B6:D7,2,FALSE),\"Not Found\")","v":"Eric Thomson"},{"$f":"IFERROR(VLOOKUP(C8,'Department (2)'!C6:E7,2,FALSE),\"Not Found\")","v":"Logistic"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B9,'Department (2)'!B7:D8,2,FALSE),\"Not Found\")","v":"Not Found"},{"$f":"IFERROR(VLOOKUP(C9,'Department (2)'!C7:E8,2,FALSE),\"Not Found\")","v":"Not Found"}]