{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["INDEX","VBA"],"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":"INDEX","index":0,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,5,2,8]]}
["David"]
["Ralph","Transpose Every N Rows to Columns",null,null,null,null,null,null,null,null,null,{"$f":"ROW(B5)","v":5}]
["Joe",null,null,null,null,"Use INDEX Function to Transpose Every N Rows to Columns"]
["Anny","Sales Rep","ID","Rev Earned",null,null,null,null,null,null,null,"David",null,"David"]
["Bob","David",20201,72366,null,{"$f":"INDEX($A:$A,ROW(A1)*4-4+COLUMN(A1))","v":"David"},{"$f":"INDEX($A:$A,ROW(B1)*4-4+COLUMN(B1))","v":"Ralph"},{"$f":"INDEX($A:$A,ROW(C1)*4-4+COLUMN(C1))","v":"Joe"},{"$f":"INDEX($A:$A,ROW(D1)*4-4+COLUMN(D1))","v":"Anny"},null,null,"Ralph",null,"Ralph"]
["Emma","Ralph",20202,63885,null,{"$f":"INDEX($A:$A,ROW(A2)*4-4+COLUMN(A2))","v":"Bob"},{"$f":"INDEX($A:$A,ROW(B2)*4-4+COLUMN(B2))","v":"Emma"},{"$f":"INDEX($A:$A,ROW(C2)*4-4+COLUMN(C2))","v":"Ena"},{"$f":"INDEX($A:$A,ROW(D2)*4-4+COLUMN(D2))","v":"Vinchant"},null,null,"Joe",null,"Joe"]
["Ena","Joe",20203,76811,null,{"$f":"INDEX($A:$A,ROW(A3)*4-4+COLUMN(A3))","v":"Dalton"},{"$f":"INDEX($A:$A,ROW(B3)*4-4+COLUMN(B3))","v":"Cathy"},{"$f":"INDEX($A:$A,ROW(C3)*4-4+COLUMN(C3))","v":"David"},{"$f":"INDEX($A:$A,ROW(D3)*4-4+COLUMN(D3))","v":"Ralph"},null,null,"Anny",null,"Anny"]
["Vinchant","Anny",20204,66666,null,null,null,null,null,null,null,"Bob",null,"Bob"]
["Dalton","Bob",20205,50057,null,null,null,null,null,null,null,"Emma",null,"Emma"]
["Cathy","Emma",20206,77159,null,null,null,null,null,null,null,"Ena",null,"Ena"]
["David","Ena",20207,60724,null,null,null,null,null,null,null,"Vinchant",null,"Vinchant"]
["Ralph","Vinchant",20208,78390,null,null,null,null,null,null,null,"Dalton",null,"Dalton"]
[null,"Dalton",20209,65400,null,null,null,null,null,null,null,"Cathy",null,"Cathy"]
[null,"Cathy",20210,59907,null,null,null,null,null,null,null,"David",null,"David"]
[null,"David",20211,64324,null,null,null,null,null,null,null,"Ralph",null,"Ralph"]
[null,"Ralph",20212,63813]

{"sheet":"VBA","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,5,2,8]]}
[]
[null,"Run a VBA Code to Transpose Every N Rows to Columns"]
[null,null,null,null,null,"Run a VBA Code to Transpose Every N Rows to Columns"]
[null,"Sales Rep","ID","Rev Earned"]
[null,"David",20201,72366,null,"David","Ralph","Joe","Anny"]
[null,"Ralph",20202,63885,null,"Bob","Emma","Ena","Vinchant"]
[null,"Joe",20203,76811,null,"Dalton","Cathy","David","Ralph"]
[null,"Anny",20204,66666]
[null,"Bob",20205,50057]
[null,"Emma",20206,77159]
[null,"Ena",20207,60724]
[null,"Vinchant",20208,78390]
[null,"Dalton",20209,65400]
[null,"Cathy",20210,59907]
[null,"David",20211,64324]
[null,"Ralph",20212,63813]