{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Go To Special","IF Function","Find and Replace","Go To Special with formula","Power Query","Power Query Generated 1","Powery Query with grouping","Power Query Generated 2","VBA Macros"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Go To Special","index":0,"n_rows":11,"n_cols":3,"rows_kept":11}
["ID","Item","Description"]
[1,"Laptop","N/A"]
[2,"Mouse","Wireless mouse"]
[3,"Keyboard","␣"]
[4,"Monitor",{"$f":"\"\"","v":""}]
[5,"Chair","Ergonomic chair"]
[6,"Desk","N/A"]
[7,"Headset","Noise-cancelling"]
[8,"Webcam","␣"]
[9,"Printer",{"$f":"\"\"","v":""}]
[10,"Router","N/A"]

{"sheet":"IF Function","index":1,"n_rows":11,"n_cols":4,"rows_kept":11}
["ID","Item","Description","Final Output"]
[1,"Laptop",null,{"$f":"IF(C2=\"\", \"N/A\", C2)","v":"N/A"}]
[2,"Mouse","Wireless mouse",{"$f":"IF(C3=\"\", \"N/A\", C3)","v":"Wireless mouse"}]
[3,"Keyboard","␣","␣"]
[4,"Monitor",{"$f":"\"\"","v":""},"N/A"]
[5,"Chair","Ergonomic chair","Ergonomic chair"]
[6,"Desk",null,"N/A"]
[7,"Headset","Noise-cancelling","Noise-cancelling"]
[8,"Webcam","␣","␣"]
[9,"Printer",{"$f":"\"\"","v":""},"N/A"]
[10,"Router",null,"N/A"]

{"sheet":"Find and Replace","index":2,"n_rows":11,"n_cols":3,"rows_kept":11}
["ID","Item","Description"]
[1,"Laptop","N/A"]
[2,"Mouse","Wireless mouse"]
[3,"Keyboard","␣"]
[4,"Monitor",{"$f":"\"\"","v":""}]
[5,"Chair","Ergonomic chair"]
[6,"Desk","N/A"]
[7,"Headset","Noise-cancelling"]
[8,"Webcam","␣"]
[9,"Printer",{"$f":"\"\"","v":""}]
[10,"Router","N/A"]

{"sheet":"Go To Special with formula","index":3,"n_rows":11,"n_cols":3,"rows_kept":11}
["ID","Region","Sales"]
[1,"North",1200]
[2,{"$f":"B2","v":"North"},1500]
[3,"North",1700]
[4,"South",900]
[5,{"$f":"B5","v":"South"},1100]
[6,"East",800]
[7,{"$f":"B7","v":"East"},950]
[8,"West",1400]
[9,{"$f":"B9","v":"West"},1600]
[10,"West",1750]

{"sheet":"Power Query","index":4,"n_rows":11,"n_cols":3,"rows_kept":11}
["ID","Item","Description"]
[1,"Laptop"]
[2,"Mouse","Wireless mouse"]
[3,"Keyboard","␣"]
[4,"Monitor",{"$f":"\"\"","v":""}]
[5,"Chair","Ergonomic chair"]
[6,"Desk"]
[7,"Headset","Noise-cancelling"]
[8,"Webcam","␣"]
[9,"Printer",{"$f":"\"\"","v":""}]
[10,"Router"]

{"sheet":"Power Query Generated 1","index":5,"n_rows":11,"n_cols":7,"rows_kept":11}
["ID","Item","Description"]
[1,"Laptop","N/A"]
[2,"Mouse","Wireless mouse"]
[3,"Keyboard","␣"]
[4,"Monitor",""]
[5,"Chair","Ergonomic chair",{"$nulls":3}," "]
[6,"Desk","N/A"]
[7,"Headset","Noise-cancelling"]
[8,"Webcam","␣"]
[9,"Printer",""]
[10,"Router","N/A"]

{"sheet":"Powery Query with grouping","index":6,"n_rows":11,"n_cols":3,"rows_kept":11}
["ID","Region","Sales"]
[1,"North",1200]
[2,null,1500]
[3,null,1700]
[4,"South",900]
[5,null,1100]
[6,"East",800]
[7,null,950]
[8,"West",1400]
[9,null,1600]
[10,null,1750]

{"sheet":"Power Query Generated 2","index":7,"n_rows":11,"n_cols":3,"rows_kept":11}
["ID","Region","Sales"]
[1,"North",1200]
[2,"North",1500]
[3,"North",1700]
[4,"South",900]
[5,"South",1100]
[6,"East",800]
[7,"East",950]
[8,"West",1400]
[9,"West",1600]
[10,"West",1750]

{"sheet":"VBA Macros","index":8,"n_rows":11,"n_cols":3,"rows_kept":11}
["ID","Item","Description"]
[1,"Laptop","N/A"]
[2,"Mouse","Wireless mouse"]
[3,"Keyboard","␣"]
[4,"Monitor",{"$f":"\"\"","v":""}]
[5,"Chair","Ergonomic chair"]
[6,"Desk","N/A"]
[7,"Headset","Noise-cancelling"]
[8,"Webcam","␣"]
[9,"Printer",{"$f":"\"\"","v":""}]
[10,"Router","N/A"]