{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["SampleDataSet","LastDimension","TransposeForBothDimension","Data1","Data2","Result"],"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":"SampleDataSet","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,2,3,3],[1,1,1,3]]}
[]
[null,"ReDim Preserve 2D Array in Excel VBA"]
[]
[null,null,"Columns"]
[null,"Rows",1,2]
[null,1,"Ronin",25000]
[null,2,"John",26000]
[null,3,"Jimmy",20000]

{"sheet":"LastDimension","index":1,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,2,3,4],[1,1,1,4],[1,9,1,12],[3,10,3,12]]}
[]
[null,"Increase Column Dimension",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,null,"Columns",null,null,null,null,null,null,null,"Columns"]
[null,"Rows",1,2,3,null,null,null,null,"Rows",1,2,3]
[null,1,"Ronin",25000,"Developer",null,null,null,null,1]
[null,2,"John",26000,"IT",null,null,null,null,2]
[null,3,"Jimmy",20000,"Software",null,null,null,null,3]

{"sheet":"TransposeForBothDimension","index":2,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,2,3,4],[1,9,1,12],[3,10,3,12]]}
[]
[null,"Increase Both Dimensions",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,null,"Columns",null,null,null,null,null,null,null,"Columns"]
[null,"Rows",1,2,3,null,null,null,null,"Rows",1,2,3]
[null,1,"Ronin",25000,"Developer",null,null,null,null,1]
[null,2,"John",26000,"IT",null,null,null,null,2]
[null,3,"Jimmy",20000,"Software",null,null,null,null,3]
[null,4,"Smith",28000,"Writer",null,null,null,null,4]

{"sheet":"Data1","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,2,3,4]]}
[]
[null,"Combine Array Elements from Multiple Worksheets"]
[]
[null,null,"Columns"]
[null,"Rows",1,2,3]
[null,1,"Ronin",25000,"Developer"]
[null,2,"John",26000,"IT"]
[null,3,"Jimmy",20000,"Software"]
[null,4,"Smith",28000,"Writer"]

{"sheet":"Data2","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,2,3,4]]}
[]
[null,"Combine Array Elements from Multiple Worksheets"]
[]
[null,null,"Columns"]
[null,"Rows",1,2,3]
[null,1,"Robin",30000,"Marketing"]
[null,2,"Maddison",35000,"IT"]
[null,3,"Jill",32000,"Software"]
[null,4,"Jim",40000,"Writer"]

{"sheet":"Result","index":5,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Combine Array Elements from Multiple Worksheets",null,null,null,null,"Try Yourself"]
[]
[null,"Name","Salary","Department",null,null,"Name","Salary","Department"]
[null,"Ronin",25000,"Developer"]
[null,"John",26000,"IT"]
[null,"Jimmy",20000,"Software"]
[null,"Smith",28000,"Writer"]
[null,"Robin",30000,"Marketing"]
[null,"Maddison",35000,"IT"]
[null,"Jill",32000,"Software"]
[null,"Jim",40000,"Writer"]