{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sample Dataset","Find and Replace","Go To Special Command","Using Power Query","Using Power Query Table","Applying VBA","Using 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":"Sample Dataset","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Dataset"]
[]
[null,"Product ID","Product Name","Sales"]
[]
[]
[null,"#4501","Shirt",659]
[]
[null,"#4502","Pant",432]
[]
[]
[null,"#4503","Trouser",250]
[]
[null,"#4504","T-Shirt",500]

{"sheet":"Find and Replace","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combining Find and Replace Command"]
[]
[null,"Product ID","Product Name","Sales"]
[null,{"$f":"B6","v":"#4501"},"Shirt",659]
[null,"#4501","Shirt",659]
[null,"#4501","Shirt",659]
[null,{"$f":"B9","v":"#4502"},{"$f":"C9","v":"Pant"},{"$f":"D9","v":432}]
[null,"#4502","Pant",432]
[null,{"$f":"B11","v":"#4503"},"Trouser",250]
[null,"#4503","Trouser",250]
[null,"#4503","Trouser",250]
[null,{"$f":"B14","v":"#4504"},{"$f":"C14","v":"T-Shirt"},{"$f":"D14","v":500}]
[null,"#4504","T-Shirt",500]

{"sheet":"Go To Special Command","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merging Go To Special Command with a Formula"]
[]
[null,"Product ID","Product Name","Sales"]
[null,{"$f":"B6","v":"#4501"},"Shirt",659]
[null,"#4501","Shirt",659]
[null,"#4501","Shirt",659]
[null,{"$f":"B9","v":"#4502"},{"$f":"C9","v":"Pant"},{"$f":"D9","v":432}]
[null,"#4502","Pant",432]
[null,{"$f":"B11","v":"#4503"},"Trouser",250]
[null,"#4503","Trouser",250]
[null,"#4503","Trouser",250]
[null,{"$f":"B14","v":"#4504"},{"$f":"C14","v":"T-Shirt"},{"$f":"D14","v":500}]
[null,"#4504","T-Shirt",500]

{"sheet":"Using Power Query","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Power Query"]
[]
[null,"Product ID","Product Name","Sales"]
[]
[]
[null,"#4501","Shirt",659]
[]
[null,"#4502","Pant",432]
[]
[]
[null,"#4503","Trouser",250]
[]
[null,"#4504","T-Shirt",500]

{"sheet":"Using Power Query Table","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Product ID","Product Name","Sales"]
["#4501","Shirt",659]
["#4501","Shirt",659]
["#4501","Shirt",659]
["#4502","Pant",432]
["#4502","Pant",432]
["#4503","Trouser",250]
["#4503","Trouser",250]
["#4503","Trouser",250]
["#4504","T-Shirt",500]
["#4504","T-Shirt",500]

{"sheet":"Applying VBA","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying VBA"]
[]
[null,"Product ID","Product Name","Sales"]
[null,"#4501","Shirt",659]
[null,"#4501","Shirt",659]
[null,"#4501","Shirt",659]
[null,"#4502","Pant",432]
[null,"#4502","Pant",432]
[null,"#4503","Trouser",250]
[null,"#4503","Trouser",250]
[null,"#4503","Trouser",250]
[null,"#4504","T-Shirt",500]
[null,"#4504","T-Shirt",500]

{"sheet":"Using VBA","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA"]
[]
[null,"Product ID","Product Name","Sales"]
[null,"#4501","Shirt",659]
[null,"#4501","Shirt",659]
[null,"#4501","Shirt",659]
[null,"#4502","Pant",432]
[null,"#4502","Pant",432]
[null,"#4503","Trouser",250]
[null,"#4503","Trouser",250]
[null,"#4503","Trouser",250]
[null,"#4504","T-Shirt",500]
[null,"#4504","T-Shirt",500]