{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Go to Special","Fill Handle","Formula","Power Query","VBA macro"],"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":"Dataset","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Fill Down to Next Value "]
[]
[null,"Product Name","Company  Name","Product Serial No"]
[null,"Gpu","Nvidia","PD2021547"]
[null,null,null,"PD2021785"]
[null,null,null,"PD2021857"]
[null,null,"AMD","PD2021698"]
[null,null,null,"PD2021587"]
[null,null,null,"PD2021458"]
[null,null,"Zotac","PD2021357"]
[null,null,null,"PD2021478"]
[null,null,null,"PD2021478"]
[null,null,"Gigabyte","PD2021369"]
[null,null,null,"PD2021951"]
[null,null,null,"PD2021357"]

{"sheet":"Go to Special","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Fill Down to Next Value "]
[]
[null,"Product Name","Company Name","Product Sr No"]
[null,"Gpu","Nvidia","PD2021547"]
[null,{"$f":"B5","v":"Gpu"},{"$f":"C5","v":"Nvidia"},"PD2021785"]
[null,"Gpu","Nvidia","PD2021857"]
[null,"Gpu","AMD","PD2021698"]
[null,"Gpu",{"$f":"C8","v":"AMD"},"PD2021587"]
[null,"Gpu","AMD","PD2021458"]
[null,"Gpu","Zotac","PD2021357"]
[null,"Gpu",{"$f":"C11","v":"Zotac"},"PD2021478"]
[null,"Gpu","Zotac","PD2021478"]
[null,"Gpu","Gigabyte","PD2021369"]
[null,{"$f":"B14","v":"Gpu"},"Gigabyte","PD2021951"]
[null,"Gpu","Gigabyte","PD2021357"]

{"sheet":"Fill Handle","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Fill Down to Next Value "]
[]
[null,"Product Name","Company  Name","Product Serial No"]
[null,"Gpu","Nvidia","PD2021547"]
[null,"Gpu","Nvidia","PD2021785"]
[null,"Gpu","Nvidia","PD2021857"]
[null,"Gpu","AMD","PD2021698"]
[null,"Gpu","AMD","PD2021587"]
[null,"Gpu","AMD","PD2021458"]
[null,"Gpu","Zotac","PD2021357"]
[null,"Gpu","Zotac","PD2021478"]
[null,"Gpu","Zotac","PD2021478"]
[null,"Gpu","Gigabyte","PD2021369"]
[null,"Gpu","Gigabyte","PD2021951"]
[null,"Gpu","Gigabyte","PD2021357"]
[null,"Gpu","Sapphire","PD2021432"]

{"sheet":"Formula","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Fill Down to Next Value "]
[]
[null,"Product Name",null,"Company  Name","Product Serial No"]
[null,"Gpu","Gpu","Nvidia","PD2021547"]
[null,{"$f":"IF(C6=\"\",B5,C6)","v":"Gpu"},null,"Nvidia","PD2021785"]
[null,null,null,"Nvidia","PD2021857"]
[null,null,null,"AMD","PD2021698"]
[null,null,null,"AMD","PD2021587"]
[null,null,null,"AMD","PD2021458"]
[null,null,null,"Zotac","PD2021357"]
[null,null,null,"Zotac","PD2021478"]
[null,null,null,"Zotac","PD2021478"]
[null,null,null,"Gigabyte","PD2021369"]
[null,null,null,"Gigabyte","PD2021951"]
[null,null,null,"Gigabyte","PD2021357"]

{"sheet":"Power Query","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Fill Down to Next Value "]
[]
[null,"Product Name","Company Name","Product Serial No",null,"Product Name","Company Name","Product Serial No"]
[null,"Gpu","Nvidia","PD2021547",null,"Gpu","Nvidia","PD2021547"]
[null,null,null,"PD2021785",null,"Gpu","Nvidia","PD2021785"]
[null,null,null,"PD2021857",null,"Gpu","Nvidia","PD2021857"]
[null,null,"AMD","PD2021698",null,"Gpu","AMD","PD2021698"]
[null,null,null,"PD2021587",null,"Gpu","AMD","PD2021587"]
[null,null,null,"PD2021458",null,"Gpu","AMD","PD2021458"]
[null,null,"Zotac","PD2021357",null,"Gpu","Zotac","PD2021357"]
[null,null,null,"PD2021478",null,"Gpu","Zotac","PD2021478"]
[null,null,null,"PD2021478",null,"Gpu","Zotac","PD2021478"]
[null,null,"Gigabyte","PD2021369",null,"Gpu","Gigabyte","PD2021369"]
[null,null,null,"PD2021951",null,"Gpu","Gigabyte","PD2021951"]
[null,null,null,"PD2021357",null,"Gpu","Gigabyte","PD2021357"]

{"sheet":"VBA macro","index":5,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Fill Down to Next Value "]
[]
[null,"Product Name","Company  Name","Product Serial No"]
[null,"Gpu","Nvidia","PD2021547"]
[null,"Gpu","Nvidia","PD2021785"]
[null,"Gpu","Nvidia","PD2021857"]
[null,"Gpu","AMD","PD2021698"]
[null,"Gpu","AMD","PD2021587"]
[null,"Gpu","AMD","PD2021458"]
[null,"Gpu","Zotac","PD2021357"]
[null,"Gpu","Zotac","PD2021478"]
[null,"Gpu","Zotac","PD2021478"]
[null,"Gpu","Gigabyte","PD2021369"]
[null,"Gpu","Gigabyte","PD2021951"]
[null,"Gpu","Gigabyte","PD2021357"]