{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"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":"Sheet1","index":0,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,36,4],[15,5,36,9],[13,0,13,4]]}
["Range",null,"Range",null,"Range",null,"Range",1,2,3,4,5,6,7,8,9,10]
[1,"Moving range to array",1,null,1]
[2,null,2,null,2]
[3,null,3,null,3]
[4,"Arr = Range(\"A1:a10\")",4,"Moving it to 10 rows and 1 column ",4,"Moving it to 1 rows and 10 column "]
[5,null,5,null,5,"Then transpose should be use because rows are moviing into column "]
[6,null,6,null,6]
[7,null,7,null,7]
[8,null,8,null,8]
[9,null,9,null,9]
[10,null,10,null,10]
[null,null,"10 rows and 1 column ",null,".Resize(ubound(arr,1),1)"]
[null,null,"(1 to 10,1 to 1) "]
["First code",null,null,null,null,"Second Code"]
[]
["Sub test()\n\nDim Arr() As Variant\nArr = Range(\"A1:a10\")\n\nDim R As Long\nDim C As Long\nFor R = 1 To UBound(Arr, 1) ' First array dimension is rows.\n    For C = 1 To UBound(Arr, 2) ' Second array dimension is columns.\n        Debug.Print Arr(R, C)\n    Next C\nNext R\n\nDim Destination As Range\nSet Destination = Range(\"K1\")\n\n'10 rows 1 column to transpose 10 row 1 column\nSet Destination = Destination.Resize(UBound(Arr, 1), 1)\nDestination.Value = Arr\n\nEnd Sub",null,null,null,null,"Sub test()\n\nDim Arr() As Variant\nArr = Range(\"A1:a10\")\n\nDim R As Long\nDim C As Long\nFor R = 1 To UBound(Arr, 1) ' First array dimension is rows.\n    For C = 1 To UBound(Arr, 2) ' Second array dimension is columns.\n        Debug.Print Arr(R, C)\n    Next C\nNext R\n\nDim Destination As Range\nSet Destination = Range(\"K1\")\n\n'10 rows 1 column to transpose 10 row 1 column\nSet Destination = Destination.Resize(1, UBound(Arr, 1))\nDestination.Value = Application.Transpose(Arr)\n\nEnd Sub"]

{"sheet":"Sheet2","index":1,"n_rows":11,"n_cols":20,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Range",null,null,null,null,null,null,null,null,null,"Range",1,2,3,4,5,6,7,8,9]
[1,null,null,null,null,null,null,null,null,null,1]
[2,null,null,null,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,null,null,null,3]
[4,null,null,null,null,null,null,null,null,null,4]
[5,null,null,null,null,null,null,null,null,null,5]
[6,null,null,null,null,null,null,null,null,null,6]
[7,null,null,null,null,null,null,null,null,null,7]
[8,null,null,null,null,null,null,null,null,null,8]
[9,null,null,null,null,null,null,null,null,null,9]
[10]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}