{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Using Fill Command","Using Go to Special Tool","Table2","Using Power Query Editor","Using VBA","Value from Left"],"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":"Using Fill Command","index":0,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Using Fill Command",null,null,null,null,"Try Yourself"]
[]
[null,"Sales Representative","Month","Units Sold","Amount",null,"Sales Representative","Month","Units Sold","Amount"]
[null,"Jane","Jan",182,15101,null,"Jane","Jan",182,15101]
[null,"Jane","Feb",3350,33500,null,null,"Feb",3350,33500]
[null,"Jane","Mar",114,34230,null,null,"Mar",114,34230]
[null,"George","Jan",135,32993,null,"George","Jan",135,32993]
[null,"George","Feb",401,35205,null,null,"Feb",401,35205]
[null,"George","Mar",357,4598,null,null,"Mar",357,4598]
[null,"Beth","Jan",509,12506,null,"Beth","Jan",509,12506]
[null,"Beth","Feb",414,38993,null,null,"Feb",414,38993]
[null,"Beth","Mar",53,9092,null,null,"Mar",53,9092]
[null,"Dan","Jan",323,12332,null,"Dan","Jan",323,12332]
[null,"Dan","Feb",283,4500,null,null,"Feb",283,4500]
[null,"Dan","Mar",401,8054,null,null,"Mar",401,8054]

{"sheet":"Using Go to Special Tool","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Using Go to Special Tool",null,null,null,null,"Try Yourself"]
[]
[null,"Sales Representative","Month","Units Sold","Amount",null,"Sales Representative","Month","Units Sold","Amount"]
[null,"Jane","Jan",182,15101,null,"Jane","Jan",182,15101]
[null,"Jane","Feb",3350,33500,null,null,"Feb",3350,33500]
[null,"Jane","Mar",114,34230,null,null,"Mar",114,34230]
[null,"George","Jan",135,32993,null,"George","Jan",135,32993]
[null,"George","Feb",401,35205,null,null,"Feb",401,35205]
[null,"George","Mar",357,4598,null,null,"Mar",357,4598]
[null,"Beth","Jan",509,12506,null,"Beth","Jan",509,12506]
[null,"Beth","Feb",414,38993,null,null,"Feb",414,38993]
[null,"Beth","Mar",53,9092,null,null,"Mar",53,9092]
[null,"Dan","Jan",323,12332,null,"Dan","Jan",323,12332]
[null,"Dan","Feb",283,4500,null,null,"Feb",283,4500]
[null,"Dan","Mar",401,8054,null,null,"Mar",401,8054]

{"sheet":"Table2","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Sales Representative","Month","Units Sold","Amount"]
["Jane","Jan",182,15101]
["Jane","Feb",3350,33500]
["Jane","Mar",114,34230]
["George","Jan",135,32993]
["George","Feb",401,35205]
["George","Mar",357,4598]
["Beth","Jan",509,12506]
["Beth","Feb",414,38993]
["Beth","Mar",53,9092]
["Dan","Jan",323,12332]
["Dan","Feb",283,4500]
["Dan","Mar",401,8054]

{"sheet":"Using Power Query Editor","index":3,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Using Power Query Editor",null,null,null,null,"Try Yourself"]
[]
[null,"Sales Representative","Month","Units Sold","Amount",null,"Sales Representative","Month","Units Sold","Amount"]
[null,"Jane","Jan",182,15101,null,"Jane","Jan",182,15101]
[null,null,"Feb",3350,33500,null,null,"Feb",3350,33500]
[null,null,"Mar",114,34230,null,null,"Mar",114,34230]
[null,"George","Jan",135,32993,null,"George","Jan",135,32993]
[null,null,"Feb",401,35205,null,null,"Feb",401,35205]
[null,null,"Mar",357,4598,null,null,"Mar",357,4598]
[null,"Beth","Jan",509,12506,null,"Beth","Jan",509,12506]
[null,null,"Feb",414,38993,null,null,"Feb",414,38993]
[null,null,"Mar",53,9092,null,null,"Mar",53,9092]
[null,"Dan","Jan",323,12332,null,"Dan","Jan",323,12332]
[null,null,"Feb",283,4500,null,null,"Feb",283,4500]
[null,null,"Mar",401,8054,null,null,"Mar",401,8054]

{"sheet":"Using VBA","index":4,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Using VBA",null,null,null,null,"Try Yourself"]
[]
[null,"Sales Representative","Month","Units Sold","Amount",null,"Sales Representative","Month","Units Sold","Amount"]
[null,"Jane","Jan",182,15101,null,"Jane","Jan",182,15101]
[null,"Jane","Feb",3350,33500,null,null,"Feb",3350,33500]
[null,"Jane","Mar",114,34230,null,null,"Mar",114,34230]
[null,"George","Jan",135,32993,null,"George","Jan",135,32993]
[null,"George","Feb",401,35205,null,null,"Feb",401,35205]
[null,"George","Mar",357,4598,null,null,"Mar",357,4598]
[null,"Beth","Jan",509,12506,null,"Beth","Jan",509,12506]
[null,"Beth","Feb",414,38993,null,null,"Feb",414,38993]
[null,"Beth","Mar",53,9092,null,null,"Mar",53,9092]
[null,"Dan","Jan",323,12332,null,"Dan","Jan",323,12332]
[null,"Dan","Feb",283,4500,null,null,"Feb",283,4500]
[null,"Dan","Mar",401,8054,null,null,"Mar",401,8054]

{"sheet":"Value from Left","index":5,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,13],[10,1,10,13]]}
[]
[null,"Fill Blank Cells in Excel with Value from Left"]
[]
[null,"Sales Representative","Jane","Jane","Jane","George","George","George","Beth","Beth","Beth","Dan","Dan","Dan"]
[null,"Month","Jan","Feb","Mar","Jan","Feb","Mar","Jan","Feb","Mar","Jan","Feb","Mar"]
[null,"Units Sold",182,3350,114,135,401,357,509,414,53,323,283,401]
[null,"Amount",15101,33500,34230,32993,35205,4598,12506,38993,9092,12332,4500,8054]
[]
[]
[]
[null,"Try Yourself"]
[]
[null,"Sales Representative","Jane",null,null,"George",null,null,"Beth",null,null,"Dan"]
[null,"Month","Jan","Feb","Mar","Jan","Feb","Mar","Jan","Feb","Mar","Jan","Feb","Mar"]
[null,"Units Sold",182,3350,114,135,401,357,509,414,53,323,283,401]
[null,"Amount",15101,33500,34230,32993,35205,4598,12506,38993,9092,12332,4500,8054]