{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Paste Special","VBA","Dataset 1","Vertical to Horizontal","Shortcut"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sales Report"]
[]
[null,"Salesman","Item","Qty"]
[null,"Harry","Pizza",15]
[null,"Fred","Burger",20]
[null,"Arthur","Sandwich",25]
[null,"Maria","Burger",22]
[null,"Jack","Fries",18]
[null,"Richard","Pizza",13]

{"sheet":"Paste Special","index":1,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,11,1,13]]}
[]
[null,"Using Paste Special Option",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Salesman","Item","Qty",null,null,null,null,null,null,null,"Salesman","Item","Qty"]
[null,"Harry","Pizza",15,null,null,null,null,null,null,null,"Harry","Pizza",15]
[null,"Fred","Burger",20,null,null,null,null,null,null,null,"Fred","Burger",20]
[null,"Arthur","Sandwich",25,null,null,null,null,null,null,null,"Arthur","Sandwich",25]
[null,"Maria","Burger",22,null,null,null,null,null,null,null,"Maria","Burger",22]
[null,"Jack","Fries",18,null,null,null,null,null,null,null,"Jack","Fries",18]
[null,"Richard","Pizza",13,null,null,null,null,null,null,null,"Richard","Pizza",13]
[]
[null,"Salesman","Harry","Fred","Arthur","Maria","Jack","Richard"]
[null,"Item","Pizza","Burger","Sandwich","Burger","Fries","Pizza"]
[null,"Qty",15,20,25,22,18,13]

{"sheet":"VBA","index":2,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,11,1,13]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Salesman","Item","Qty",null,null,null,null,null,null,null,"Salesman","Item","Qty"]
[null,"Harry","Pizza",15,null,null,null,null,null,null,null,"Harry","Pizza",15]
[null,"Fred","Burger",20,null,null,null,null,null,null,null,"Fred","Burger",20]
[null,"Arthur","Sandwich",25,null,null,null,null,null,null,null,"Arthur","Sandwich",25]
[null,"Maria","Burger",22,null,null,null,null,null,null,null,"Maria","Burger",22]
[null,"Jack","Fries",18,null,null,null,null,null,null,null,"Jack","Fries",18]
[null,"Richard","Pizza",13,null,null,null,null,null,null,null,"Richard","Pizza",13]
[]
[null,"Salesman","Harry","Fred","Arthur","Maria","Jack","Richard"]
[null,"Item","Pizza","Burger","Sandwich","Burger","Fries","Pizza"]
[null,"Qty",15,20,25,22,18,13]

{"sheet":"Dataset 1","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Monthly Sales of ABC Company"]
[]
[null,"Sales Person","Product","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01"]
[null,"Jimmy","Laptop",5503,8155,7266,8177,8411]
[null,"Harry","Laptop",5696,7018,5873,5060,7956]
[null,"Sarah","Laptop",6001,7156,7545,5634,8067]
[null,"Jimmy","Smartphone",5921,6398,6054,6230,5494]
[null,"Harry","Smartphone",6952,8176,7698,5130,5526]
[null,"Sarah","Smartphone",6339,7317,8481,8196,6185]
[null,"Jimmy","Custom PC",6627,5196,7671,7250,7131]
[null,"Harry","Custom PC",5025,8032,5236,6115,7766]
[null,"Sarah","Custom PC",6684,5898,6965,8431,7984]
[null,"Jimmy","IPad",7736,6438,5950,5661,7669]

{"sheet":"Vertical to Horizontal","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Changing Vertical Text to Horizontal"]
[]
[null,"Sales Person","Product","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01"]
[null,"Jimmy","Laptop",5503,8155,7266,8177,8411]
[null,"Harry","Laptop",5696,7018,5873,5060,7956]
[null,"Sarah","Laptop",6001,7156,7545,5634,8067]
[null,"Jimmy","Smartphone",5921,6398,6054,6230,5494]
[null,"Harry","Smartphone",6952,8176,7698,5130,5526]
[null,"Sarah","Smartphone",6339,7317,8481,8196,6185]
[null,"Jimmy","Custom PC",6627,5196,7671,7250,7131]
[null,"Harry","Custom PC",5025,8032,5236,6115,7766]
[null,"Sarah","Custom PC",6684,5898,6965,8431,7984]
[null,"Jimmy","IPad",7736,6438,5950,5661,7669]

{"sheet":"Shortcut","index":5,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,11,1,13]]}
[]
[null,"Shortcut to Paste Horizontally",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Salesman","Item","Qty",null,null,null,null,null,null,null,"Salesman","Item","Qty"]
[null,"Harry","Pizza",15,null,null,null,null,null,null,null,"Harry","Pizza",15]
[null,"Fred","Burger",20,null,null,null,null,null,null,null,"Fred","Burger",20]
[null,"Arthur","Sandwich",25,null,null,null,null,null,null,null,"Arthur","Sandwich",25]
[null,"Maria","Burger",22,null,null,null,null,null,null,null,"Maria","Burger",22]
[null,"Jack","Fries",18,null,null,null,null,null,null,null,"Jack","Fries",18]
[null,"Richard","Pizza",13,null,null,null,null,null,null,null,"Richard","Pizza",13]
[]
[null,"Salesman","Harry","Fred","Arthur","Maria","Jack","Richard"]
[null,"Item","Pizza","Burger","Sandwich","Burger","Fries","Pizza"]
[null,"Qty",15,20,25,22,18,13]