{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["One-dimensional","Multi-dimensional","Using Paste Special","Practice Here!"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"One-dimensional","index":0,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,17]]}
[]
[null,"Applying VBA to Transpose One Dimensional Array",null,null,null,null,null,"Applying VBA to Transpose One Dimensional Array"]
[]
[null,"Product Name",2017,2018,2019,2020,null,"Product Name","Radio","Television","Smartphone","Desktop","Laptop","Washing Machine","Table Fan","Microwave Oven","Private Car","Motorcycle"]
[null,"Radio",154000,111000,175000,174000]
[null,"Television",192000,155000,127000,101000]
[null,"Smartphone",106000,119000,121000,149000]
[null,"Desktop",172000,160000,117000,131000]
[null,"Laptop",102000,154000,195000,196000]
[null,"Washing Machine",195000,125000,159000,167000]
[null,"Table Fan",144000,159000,150000,183000]
[null,"Microwave Oven",166000,193000,186000,148000]
[null,"Private Car",138000,171000,135000,197000]
[null,"Motorcycle",129000,101000,180000,194000]

{"sheet":"Multi-dimensional","index":1,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,13]]}
[]
[null,"Using VBA to Transpose Multi-Dimensional Array ",null,null,null,null,null,"Using VBA to Transpose Multi-Dimensional Array "]
[]
[null,"Product Name",2017,2018,2019,2020,null,"Product Name","Radio","Television","Smartphone","Desktop","Laptop","Washing Machine","Table Fan","Microwave Oven","Private Car","Motorcycle"]
[null,"Radio",154000,111000,175000,174000,null,2017,154000,192000,106000,172000,102000,195000,144000,166000,138000,129000]
[null,"Television",192000,155000,127000,101000,null,2018,111000,155000,119000,160000,154000,125000,159000,193000,171000,101000]
[null,"Smartphone",106000,119000,121000,149000,null,2019,175000,127000,121000,117000,195000,159000,150000,186000,135000,180000]
[null,"Desktop",172000,160000,117000,131000,null,2020,174000,101000,149000,131000,196000,167000,183000,148000,197000,194000]
[null,"Laptop",102000,154000,195000,196000]
[null,"Washing Machine",195000,125000,159000,167000]
[null,"Table Fan",144000,159000,150000,183000]
[null,"Microwave Oven",166000,193000,186000,148000]
[null,"Private Car",138000,171000,135000,197000]
[null,"Motorcycle",129000,101000,180000,194000]

{"sheet":"Using Paste Special","index":2,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,17]]}
[]
[null,"Employing VBA Paste Special Method",null,null,null,null,null,"Employing VBA Paste Special Method"]
[]
[null,"Product Name",2017,2018,2019,2020,null,"Product Name","Radio","Television","Smartphone","Desktop","Laptop","Washing Machine","Table Fan","Microwave Oven","Private Car","Motorcycle"]
[null,"Radio",154000,111000,175000,174000,null,2017,154000,192000,106000,172000,102000,195000,144000,166000,138000,129000]
[null,"Television",192000,155000,127000,101000,null,2018,111000,155000,119000,160000,154000,125000,159000,193000,171000,101000]
[null,"Smartphone",106000,119000,121000,149000,null,2019,175000,127000,121000,117000,195000,159000,150000,186000,135000,180000]
[null,"Desktop",172000,160000,117000,131000,null,2020,174000,101000,149000,131000,196000,167000,183000,148000,197000,194000]
[null,"Laptop",102000,154000,195000,196000]
[null,"Washing Machine",195000,125000,159000,167000]
[null,"Table Fan",144000,159000,150000,183000]
[null,"Microwave Oven",166000,193000,186000,148000]
[null,"Private Car",138000,171000,135000,197000]
[null,"Motorcycle",129000,101000,180000,194000]

{"sheet":"Practice Here!","index":3,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[]
[]
["Practice Here!"]
[]
["Product Name",2017,2018,2019,2020]
["Radio",154000,111000,175000,174000]
["Television",192000,155000,127000,101000]
["Smartphone",106000,119000,121000,149000]
["Desktop",172000,160000,117000,131000]
["Laptop",102000,154000,195000,196000]
["Washing Machine",195000,125000,159000,167000]
["Table Fan",144000,159000,150000,183000]
["Microwave Oven",166000,193000,186000,148000]
["Private Car",138000,171000,135000,197000]
["Motorcycle",129000,101000,180000,194000]