{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["November","December","Using Consolidate","November Table","December Table","Append1","Power Query Result","VLOOKUP to Merge by One Column","Union Sheets Using VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":11,"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":"November","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sales Data of November"]
[]
[null,"Item","Quantity"]
[null,"Product-1",32]
[null,"Product-2",44]
[null,"Product-3",21]
[null,"Product-4",26]
[null,"Product-5",49]
[null,"Product-6",36]
[null,"Product-7",36]
[null,"Product-8",18]
[null,"Product-9",31]
[null,"Product-10",12]

{"sheet":"December","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sales Data of December"]
[]
[null,"Item","Quantity"]
[null,"Product-1",47]
[null,"Product-2",35]
[null,"Product-3",33]
[null,"Product-4",24]
[null,"Product-5",30]
[null,"Product-6",47]
[null,"Product-7",48]
[null,"Product-8",40]
[null,"Product-9",35]
[null,"Product-10",38]

{"sheet":"Using Consolidate","index":2,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,5,2,6]]}
[]
[null,"Sales Data of November"]
[null,null,null,null,null,"Practice Session"]
[null,"Item","Quantity"]
[null,null,{"$f":"December!$C$5","v":47},null,null,"Item","Quantity"]
[null,null,{"$f":"November!$C$5","v":32},null,null,null,{"$f":"December!$C$5","v":47}]
[null,"Product-1",{"$f":"SUM(C5:C6)","v":79},null,null,"Item","Quantity"]
[null,null,{"$f":"December!$C$6","v":35},null,null,"Product-1"]
[null,null,{"$f":"November!$C$6","v":44}]
[null,"Product-2",{"$f":"SUM(C8:C9)","v":79}]
[null,null,{"$f":"December!$C$7","v":33},null,null,"Product-2"]
[null,null,{"$f":"November!$C$7","v":21}]
[null,"Product-3",{"$f":"SUM(C11:C12)","v":54}]
[null,null,{"$f":"December!$C$8","v":24},null,null,"Product-3"]
[null,null,{"$f":"November!$C$8","v":26}]
[null,"Product-4",{"$f":"SUM(C14:C15)","v":50}]
[null,null,{"$f":"December!$C$9","v":30},null,null,"Product-4"]
[null,null,{"$f":"November!$C$9","v":49}]
[null,"Product-5",{"$f":"SUM(C17:C18)","v":79}]
[null,null,{"$f":"December!$C$10","v":47},null,null,"Product-5"]
[null,null,{"$f":"November!$C$10","v":36}]
[null,"Product-6",{"$f":"SUM(C20:C21)","v":83}]
[null,null,{"$f":"December!$C$11","v":48},null,null,"Product-6"]
[null,null,{"$f":"November!$C$11","v":36}]
[null,"Product-7",{"$f":"SUM(C23:C24)","v":84}]
[null,null,{"$f":"December!$C$12","v":40},null,null,"Product-7"]
[null,null,{"$f":"November!$C$12","v":18}]
[null,"Product-8",{"$f":"SUM(C26:C27)","v":58}]
[null,null,{"$f":"December!$C$13","v":35},null,null,"Product-8"]
[null,null,{"$f":"November!$C$13","v":31}]
[null,"Product-9",{"$f":"SUM(C29:C30)","v":66}]
[null,null,{"$f":"December!$C$14","v":38},null,null,"Product-9"]
[null,null,{"$f":"November!$C$14","v":12}]
[null,"Product-10",{"$f":"SUM(C32:C33)","v":50}]

{"sheet":"November Table","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sales Data Table of November"]
[]
[null,"Item","Quantity"]
[null,"Product-1",32]
[null,"Product-2",44]
[null,"Product-3",21]
[null,"Product-4",26]
[null,"Product-5",49]
[null,"Product-6",36]
[null,"Product-7",36]
[null,"Product-8",18]
[null,"Product-9",31]
[null,"Product-10",12]

{"sheet":"December Table","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sales Data Table of December"]
[]
[null,"Item","Quantity"]
[null,"Product-1",47]
[null,"Product-2",35]
[null,"Product-3",33]
[null,"Product-4",24]
[null,"Product-5",30]
[null,"Product-6",47]
[null,"Product-7",48]
[null,"Product-8",40]
[null,"Product-9",35]
[null,"Product-10",38]

{"sheet":"Append1","index":5,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Item","Quantity"]
["Product-1",32]
["Product-2",44]
["Product-3",21]
["Product-4",26]
["Product-5",49]
["Product-6",36]
["Product-7",36]
["Product-8",18]
["Product-9",31]
["Product-10",12]
["Product-1",47]
["Product-2",35]
["Product-3",33]
["Product-4",24]
["Product-5",30]
["Product-6",47]
["Product-7",48]
["Product-8",40]
["Product-9",35]
["Product-10",38]

{"sheet":"Power Query Result","index":6,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Item","Quantity"]
["Product-1",47]
["Product-2",35]
["Product-3",33]
["Product-4",24]
["Product-5",30]
["Product-6",47]
["Product-7",48]
["Product-8",40]
["Product-9",35]
["Product-10",38]
["Product-1",32]
["Product-2",44]
["Product-3",21]
["Product-4",26]
["Product-5",49]
["Product-6",36]
["Product-7",36]
["Product-8",18]
["Product-9",31]
["Product-10",12]

{"sheet":"VLOOKUP to Merge by One Column","index":7,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,6,2,8]]}
[]
[null,"Using VLOOKUP to Merge Two Excel Sheets"]
[null,null,null,null,null,null,"Practice Session"]
[null,"Item","Quantity in November","Quantity in December"]
[null,"Product-1",{"$f":"VLOOKUP(B5,November!B5:C14,2,FALSE)","v":32},{"$f":"VLOOKUP(B5,December!B5:C14,2,FALSE)","v":47},null,null,"Item","Quantity in November","Quantity in December"]
[null,"Product-2",{"$f":"VLOOKUP(B6,November!B6:C15,2,FALSE)","v":44},{"$f":"VLOOKUP(B6,December!B6:C15,2,FALSE)","v":35},null,null,"Product-1"]
[null,"Product-3",{"$f":"VLOOKUP(B7,November!B7:C16,2,FALSE)","v":21},{"$f":"VLOOKUP(B7,December!B7:C16,2,FALSE)","v":33},null,null,"Product-2"]
[null,"Product-4",{"$f":"VLOOKUP(B8,November!B8:C17,2,FALSE)","v":26},{"$f":"VLOOKUP(B8,December!B8:C17,2,FALSE)","v":24},null,null,"Product-3"]
[null,"Product-5",{"$f":"VLOOKUP(B9,November!B9:C18,2,FALSE)","v":49},{"$f":"VLOOKUP(B9,December!B9:C18,2,FALSE)","v":30},null,null,"Product-4"]
[null,"Product-6",{"$f":"VLOOKUP(B10,November!B10:C19,2,FALSE)","v":36},{"$f":"VLOOKUP(B10,December!B10:C19,2,FALSE)","v":47},null,null,"Product-5"]
[null,"Product-7",{"$f":"VLOOKUP(B11,November!B11:C20,2,FALSE)","v":36},{"$f":"VLOOKUP(B11,December!B11:C20,2,FALSE)","v":48},null,null,"Product-6"]
[null,"Product-8",{"$f":"VLOOKUP(B12,November!B12:C21,2,FALSE)","v":18},{"$f":"VLOOKUP(B12,December!B12:C21,2,FALSE)","v":40},null,null,"Product-7"]
[null,"Product-9",{"$f":"VLOOKUP(B13,November!B13:C22,2,FALSE)","v":31},{"$f":"VLOOKUP(B13,December!B13:C22,2,FALSE)","v":35},null,null,"Product-8"]
[null,"Product-10",{"$f":"VLOOKUP(B14,November!B14:C23,2,FALSE)","v":12},{"$f":"VLOOKUP(B14,December!B14:C23,2,FALSE)","v":38},null,null,"Product-9"]
[null,null,null,null,null,null,"Product-10"]

{"sheet":"Union Sheets Using VBA","index":8,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Sales Data of November",null,null,"Sales Data of December"]
[]
[null,"Item","Quantity",null,"Item","Quantity"]
[null,"Product-1",32,null,"Product-1",47]
[null,"Product-2",44,null,"Product-2",35]
[null,"Product-3",21,null,"Product-3",33]
[null,"Product-4",26,null,"Product-4",24]
[null,"Product-5",49,null,"Product-5",30]
[null,"Product-6",36,null,"Product-6",47]
[null,"Product-7",36,null,"Product-7",48]
[null,"Product-8",18,null,"Product-8",40]
[null,"Product-9",31,null,"Product-9",35]
[null,"Product-10",12,null,"Product-10",38]