{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Using Clipboard (Step 1)","Using Clipboard(Step 2)","Employing Paste Option","Applying VBA","Applying VBA(output)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":6},"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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Pasting Pivot Table Values with Formatting"]
[]
[null,"State","Product","Sales"]
[null,"Texas","Cupcake",500]
[null,"Florida","Brownie",700]
[null,"Florida","Coffee",1200]
[null,"Texas","Coffee",1000]
[null,"Florida","Cupcake",700]
[null,"Texas","Brownie",980]

{"sheet":"Using Clipboard (Step 1)","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using Clipboard",null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"State","Product","Sales",null,null,null,null,null,"State","Product","Sales"]
[null,"Texas","Cupcake",500,null,null,null,null,null,"Texas","Cupcake",500]
[null,"Florida","Brownie",700,null,null,null,null,null,"Florida","Brownie",700]
[null,"Florida","Coffee",1200,null,null,null,null,null,"Florida","Coffee",1200]
[null,"Texas","Coffee",1000,null,null,null,null,null,"Texas","Coffee",1000]
[null,"Florida","Cupcake",700,null,null,null,null,null,"Florida","Cupcake",700]
[null,"Texas","Brownie",980,null,null,null,null,null,"Texas","Brownie",980]

{"sheet":"Using Clipboard(Step 2)","index":2,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,12]]}
[]
[null,"Using Clipboard",null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Row Labels","Sum of Sales",null,"Row Labels","Sum of Sales",null,null,null,null,null,"Row Labels","Sum of Sales"]
[null,"Florida",2600,null,"Florida",2600,null,null,null,null,null,"Florida",2600]
[null,"Brownie",700,null,"Brownie",700,null,null,null,null,null,"Brownie",700]
[null,"Coffee",1200,null,"Coffee",1200,null,null,null,null,null,"Coffee",1200]
[null,"Cupcake",700,null,"Cupcake",700,null,null,null,null,null,"Cupcake",700]
[null,"Texas",2480,null,"Texas",2480,null,null,null,null,null,"Texas",2480]
[null,"Brownie",980,null,"Brownie",980,null,null,null,null,null,"Brownie",980]
[null,"Coffee",1000,null,"Coffee",1000,null,null,null,null,null,"Coffee",1000]
[null,"Cupcake",500,null,"Cupcake",500,null,null,null,null,null,"Cupcake",500]
[null,"Grand Total",5080,null,"Grand Total",5080,null,null,null,null,null,"Grand Total",5080]

{"sheet":"Employing Paste Option","index":3,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,12]]}
[]
[null,"Employing Paste Option",null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Row Labels","Sum of Sales",null,"Row Labels","Sum of Sales",null,null,null,null,null,"Row Labels","Sum of Sales"]
[null,"Florida",2600,null,"Florida",2600,null,null,null,null,null,"Florida",2600]
[null,"Brownie",700,null,"Brownie",700,null,null,null,null,null,"Brownie",700]
[null,"Coffee",1200,null,"Coffee",1200,null,null,null,null,null,"Coffee",1200]
[null,"Cupcake",700,null,"Cupcake",700,null,null,null,null,null,"Cupcake",700]
[null,"Texas",2480,null,"Texas",2480,null,null,null,null,null,"Texas",2480]
[null,"Brownie",980,null,"Brownie",980,null,null,null,null,null,"Brownie",980]
[null,"Coffee",1000,null,"Coffee",1000,null,null,null,null,null,"Coffee",1000]
[null,"Cupcake",500,null,"Cupcake",500,null,null,null,null,null,"Cupcake",500]
[null,"Grand Total",5080,null,"Grand Total",5080,null,null,null,null,null,"Grand Total",5080]

{"sheet":"Applying VBA","index":4,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Applying VBA",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Row Labels","Sum of Sales",null,null,null,null,null,"Row Labels","Sum of Sales"]
[null,"Florida",2600,null,null,null,null,null,"Florida",2600]
[null,"Brownie",700,null,null,null,null,null,"Brownie",700]
[null,"Coffee",1200,null,null,null,null,null,"Coffee",1200]
[null,"Cupcake",700,null,null,null,null,null,"Cupcake",700]
[null,"Texas",2480,null,null,null,null,null,"Texas",2480]
[null,"Brownie",980,null,null,null,null,null,"Brownie",980]
[null,"Coffee",1000,null,null,null,null,null,"Coffee",1000]
[null,"Cupcake",500,null,null,null,null,null,"Cupcake",500]
[null,"Grand Total",5080,null,null,null,null,null,"Grand Total",5080]

{"sheet":"Applying VBA(output)","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA"]
[]
[null,"Row Labels","Sum of Sales"]
[null,"Florida",2600]
[null,"Brownie",700]
[null,"Coffee",1200]
[null,"Cupcake",700]
[null,"Texas",2480]
[null,"Brownie",980]
[null,"Coffee",1000]
[null,"Cupcake",500]
[null,"Grand Total",5080]