{"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":1,"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":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["1-PL-41440","2-P-41440","3-P-41440","4-PL-44440",null,null,null,"Result",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A1)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A1)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"1-PL-41440"}]
["1-SL-41441","2-P-41441","3-P-41441","4-SL-44444",null,null,null,"1-PL-41440",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A2)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A2)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"2-P-41440"}]
["1-P-41442","2-CL-41442","3-CL-41443","4-P-44442",null,null,null,"1-SL-41441",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A3)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A3)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"3-P-41440"}]
["1-CL-41443","2-SL-41443","3-SL-41443","4-CL-44443",null,null,null,"1-P-41442",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A4)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A4)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"4-PL-44440"}]
[null,null,null,null,null,null,null,"1-CL-41443",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A5)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A5)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"1-SL-41441"}]
[null,null,null,null,null,null,null,"2-P-41440",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A6)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A6)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"2-P-41441"}]
[null,null,null,null,null,null,null,"2-P-41441",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A7)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A7)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"3-P-41441"}]
[null,null,null,null,null,null,null,"2-CL-41442",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A8)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A8)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"4-SL-44444"}]
[null,null,null,null,null,null,null,"2-SL-41443",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A9)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A9)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"1-P-41442"}]
[null,null,null,null,null,null,null,"3-P-41440",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A10)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A10)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"2-CL-41442"}]
[null,"Output will be on sheet3",null,null,null,null,null,"3-P-41441",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A11)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A11)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"3-CL-41443"}]
[null,null,null,null,null,null,null,"3-CL-41443",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A12)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A12)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"4-P-44442"}]
[null,null,null,null,null,null,null,"3-SL-41443",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A13)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A13)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"1-CL-41443"}]
[null,null,null,null,null,null,null,"4-PL-44440",null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A14)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A14)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"2-SL-41443"}]
[null,null,null,null,null,null,null,"4-SL-44444"]
[null,null,null,null,null,null,null,"4-P-44442"]
[null,null,null,null,null,null,null,"4-CL-44443"]

{"sheet":"Sheet2","index":1,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["1-PL-41440","1-SL-41441","1-P-41442","1-CL-41443",null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A1)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A1)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"1-PL-41440"}]
["2-P-41440","2-P-41441","2-CL-41442","2-SL-41443",null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A2)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A2)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"1-SL-41441"}]
["3-P-41440","3-P-41441","3-CL-41443","3-SL-41443",null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A3)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A3)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"1-P-41442"}]
["4-PL-44440","4-SL-44444","4-P-44442","4-CL-44443",null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A4)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A4)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"1-CL-41443"},null,null,null,null,"Sub Pastevertical()"]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A5)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A5)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"2-P-41440"},null,null,null,null,"    "]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A6)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A6)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"2-P-41441"},null,null,null,null,"    Dim rngCol As Range"]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A7)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A7)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"2-CL-41442"},null,null,null,null,"    Dim rngcell As Range"]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A8)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A8)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"2-SL-41443"},null,null,null,null,"    Dim lngLastrow As Long"]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A9)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A9)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"3-P-41440"},null,null,null,null,"    For Each rngCol In Sheet1.Range(\"rngRange\").Columns"]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A10)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A10)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"3-P-41441"},null,null,null,null,"        For Each rngcell In rngCol.Cells"]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A11)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A11)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"3-CL-41443"},null,null,null,null,"            lngLastrow = Sheet2.Range(\"a\" & Rows.Count).End(xlUp).Row + 1"]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A12)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A12)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"3-SL-41443"},null,null,null,null,"        Sheet2.Range(\"a\" & lngLastrow).Value = rngcell.Value"]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A13)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A13)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"4-PL-44440"},null,null,null,null,"        Next rngcell"]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A14)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A14)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"4-SL-44444"},null,null,null,null,"    Next rngCol"]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A15)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A15)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"4-P-44442"},null,null,null,null,"End Sub"]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A16)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A16)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":"4-CL-44443"}]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A17)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A17)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A18)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A18)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A19)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A19)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A20)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A20)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A21)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A21)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A22)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A22)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A23)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A23)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A24)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A24)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A25)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A25)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A26)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A26)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A27)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A27)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"INDEX($A$1:$D$4,1+INT((ROW(A28)-1)/COLUMNS($A$1:$D$4)),MOD(ROW(A28)-1+COLUMNS($A$1:$D$4),COLUMNS($A$1:$D$4))+1)","v":{"$error":"#REF!"}}]

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