{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","SingleRow","VBA","Single Column","CONCATENATE","Transpose"],"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":"Dataset","index":0,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Name","Age","Sales"]
[null,"Aaron",29,1000]
[null,"Max",27,3400]

{"sheet":"SingleRow","index":1,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[{"$f":"OFFSET(Dataset!$B$4,((ROW()-1)*3)+(FLOOR(COLUMN()-1,3)/3),(COLUMN()-1)-(FLOOR(COLUMN()-1,3)))","v":"Name"},{"$f":"OFFSET(Dataset!$B$4,((ROW()-1)*3)+(FLOOR(COLUMN()-1,3)/3),(COLUMN()-1)-(FLOOR(COLUMN()-1,3)))","v":"Age"},{"$f":"OFFSET(Dataset!$B$4,((ROW()-1)*3)+(FLOOR(COLUMN()-1,3)/3),(COLUMN()-1)-(FLOOR(COLUMN()-1,3)))","v":"Sales"},{"$f":"OFFSET(Dataset!$B$4,((ROW()-1)*3)+(FLOOR(COLUMN()-1,3)/3),(COLUMN()-1)-(FLOOR(COLUMN()-1,3)))","v":"Aaron"},{"$f":"OFFSET(Dataset!$B$4,((ROW()-1)*3)+(FLOOR(COLUMN()-1,3)/3),(COLUMN()-1)-(FLOOR(COLUMN()-1,3)))","v":29},{"$f":"OFFSET(Dataset!$B$4,((ROW()-1)*3)+(FLOOR(COLUMN()-1,3)/3),(COLUMN()-1)-(FLOOR(COLUMN()-1,3)))","v":1000},{"$f":"OFFSET(Dataset!$B$4,((ROW()-1)*3)+(FLOOR(COLUMN()-1,3)/3),(COLUMN()-1)-(FLOOR(COLUMN()-1,3)))","v":"Max"},{"$f":"OFFSET(Dataset!$B$4,((ROW()-1)*3)+(FLOOR(COLUMN()-1,3)/3),(COLUMN()-1)-(FLOOR(COLUMN()-1,3)))","v":27},{"$f":"OFFSET(Dataset!$B$4,((ROW()-1)*3)+(FLOOR(COLUMN()-1,3)/3),(COLUMN()-1)-(FLOOR(COLUMN()-1,3)))","v":3400}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(ROW()-1)*4","v":8}]

{"sheet":"VBA","index":2,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Name","Age","Sales","Aaron",29,1000,"Max",27,3400]

{"sheet":"Single Column","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Dataset"]
[]
[null,"Name","Age","Sales",null,"Single Column"]
[null,"Aaron",29,1000,null,{"$f":"INDEX($B$4:$D$6,1+INT((ROW(A1)-1)/COLUMNS($B$4:$D$6)),MOD(ROW(A1)-1+COLUMNS($B$4:$D$6),COLUMNS($B$4:$D$6))+1)","v":"Name"}]
[null,"Max",27,3400,null,{"$f":"INDEX($B$4:$D$6,1+INT((ROW(A2)-1)/COLUMNS($B$4:$D$6)),MOD(ROW(A2)-1+COLUMNS($B$4:$D$6),COLUMNS($B$4:$D$6))+1)","v":"Age"}]
[null,null,null,null,null,{"$f":"INDEX($B$4:$D$6,1+INT((ROW(A3)-1)/COLUMNS($B$4:$D$6)),MOD(ROW(A3)-1+COLUMNS($B$4:$D$6),COLUMNS($B$4:$D$6))+1)","v":"Sales"}]
[null,null,null,null,null,{"$f":"INDEX($B$4:$D$6,1+INT((ROW(A4)-1)/COLUMNS($B$4:$D$6)),MOD(ROW(A4)-1+COLUMNS($B$4:$D$6),COLUMNS($B$4:$D$6))+1)","v":"Aaron"}]
[null,null,null,null,null,{"$f":"INDEX($B$4:$D$6,1+INT((ROW(A5)-1)/COLUMNS($B$4:$D$6)),MOD(ROW(A5)-1+COLUMNS($B$4:$D$6),COLUMNS($B$4:$D$6))+1)","v":29}]
[null,null,null,null,null,{"$f":"INDEX($B$4:$D$6,1+INT((ROW(A6)-1)/COLUMNS($B$4:$D$6)),MOD(ROW(A6)-1+COLUMNS($B$4:$D$6),COLUMNS($B$4:$D$6))+1)","v":1000}]
[null,null,null,null,null,{"$f":"INDEX($B$4:$D$6,1+INT((ROW(A7)-1)/COLUMNS($B$4:$D$6)),MOD(ROW(A7)-1+COLUMNS($B$4:$D$6),COLUMNS($B$4:$D$6))+1)","v":"Max"}]
[null,null,null,null,null,{"$f":"INDEX($B$4:$D$6,1+INT((ROW(A8)-1)/COLUMNS($B$4:$D$6)),MOD(ROW(A8)-1+COLUMNS($B$4:$D$6),COLUMNS($B$4:$D$6))+1)","v":27}]
[null,null,null,null,null,{"$f":"INDEX($B$4:$D$6,1+INT((ROW(A9)-1)/COLUMNS($B$4:$D$6)),MOD(ROW(A9)-1+COLUMNS($B$4:$D$6),COLUMNS($B$4:$D$6))+1)","v":3400}]

{"sheet":"CONCATENATE","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset"]
[]
[null,"Name","Age","Sales","Combined"]
[null,"Aaron,","29,",1000,{"$f":"CONCATENATE(B5,C5,D5)","v":"Aaron,29,1000"}]
[null,"Max,","27,",3400,{"$f":"CONCATENATE(B6,C6,D6)","v":"Max,27,3400"}]
[null,"Stacy,","30,",4400,"Stacy,30,4400"]
[null,"Micheal,","29,",1800,"Micheal,29,1800"]
[null,"Jason,","35,",3000,"Jason,35,3000"]

{"sheet":"Transpose","index":5,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Name","Age","Sales",null,"Name","Aaron","Max","Stacy","Micheal","Jason"]
[null,"Aaron",29,1000,null,"Age",29,27,30,29,35]
[null,"Max",27,3400,null,"Sales",1000,3400,4400,1800,3000]
[null,"Stacy",30,4400]
[null,"Micheal",29,1800]
[null,"Jason",35,3000]