{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Transpose Multiple Rows in Grou","paste special","Transpose Function","Indirect Function","Indirect & Address","Index Function","Table1","Ribbon","Transpose table with link","VBA"],"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":"Transpose Multiple Rows in Grou","index":0,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,8,2,11]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Physics","Chemistry","Math",null,null,null,"Name","Physics","Chemistry","Math"]
[null,"Matt",77,87,68,null,null,null,"Matt",77,87,68]
[null,"Emma",89,76,91,null,null,null,"Emma",89,76,91]
[null,"Milly",78,65,75,null,null,null,"Milly",78,65,75]
[null,"Olivia",67,89,75,null,null,null,"Olivia",67,89,75]
[null,"Emily",84,63,85,null,null,null,"Emily",84,63,85]
[null,"Paddy",78,87,91,null,null,null,"Paddy",78,87,91]

{"sheet":"paste special","index":1,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,9,2,12]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Physics","Chemistry","Math",null,null,null,null,"Name","Physics","Chemistry","Math"]
[null,"Matt",77,87,68,null,null,null,null,"Matt",77,87,68]
[null,"Emma",89,76,91,null,null,null,null,"Emma",89,76,91]
[null,"Milly",78,65,75,null,null,null,null,"Milly",78,65,75]
[null,"Olivia",67,89,75,null,null,null,null,"Olivia",67,89,75]
[null,"Emily",84,63,85,null,null,null,null,"Emily",84,63,85]
[null,"Paddy",78,87,91,null,null,null,null,"Paddy",78,87,91]
[]
[null,"Name","Matt","Emma","Milly","Olivia","Emily","Paddy"]
[null,"Physics",77,89,78,67,84,78]
[null,"Chemistry",87,76,65,89,63,87]
[null,"Math",68,91,75,75,85,91]

{"sheet":"Transpose Function","index":2,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,9,2,12]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Physics","Chemistry","Math",null,null,null,null,"Name","Physics","Chemistry","Math"]
[null,"Matt",77,87,68,null,null,null,null,"Matt",77,87,68]
[null,"Emma",89,76,91,null,null,null,null,"Emma",89,76,91]
[null,"Milly",78,65,75,null,null,null,null,"Milly",78,65,75]
[null,"Olivia",67,89,75,null,null,null,null,"Olivia",67,89,75]
[null,"Emily",84,63,85,null,null,null,null,"Emily",84,63,85]
[null,"Paddy",78,87,91,null,null,null,null,"Paddy",78,87,91]
[]
[null,{"$f":"TRANSPOSE(B5:E11)","v":"Name"},"Matt","Emma","Milly","Olivia","Emily","Paddy"]
[null,"Physics",77,89,78,67,84,78]
[null,"Chemistry",87,76,65,89,63,87]
[null,"Math",68,91,75,75,85,91]

{"sheet":"Indirect Function","index":3,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,14,2,17]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Physics","Chemistry","Math",null,null,null,null,null,null,null,null,null,"Name","Physics","Chemistry","Math"]
[null,"Matt",77,87,68,null,null,null,null,null,null,null,null,null,"Matt",77,87,68]
[null,"Emma",89,76,91,null,null,null,null,null,null,null,null,null,"Emma",89,76,91]
[null,"Milly",78,65,75,null,null,null,null,null,null,null,null,null,"Milly",78,65,75]
[null,"Olivia",67,89,75,null,null,null,null,null,null,null,null,null,"Olivia",67,89,75]
[null,"Emily",84,63,85,null,null,null,null,null,null,null,null,null,"Emily",84,63,85]
[null,"Paddy",78,87,91,null,null,null,null,null,null,null,null,null,"Paddy",78,87,91]
[]
[null,{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Name"},{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Matt"},{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Emma"},{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Milly"},{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Olivia"},{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Emily"},{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Paddy"}]
[null,{"$f":"INDIRECT(\"C\"&COLUMN()+3)","v":"Physics"},{"$f":"INDIRECT(\"C\"&COLUMN()+3)","v":77},{"$f":"INDIRECT(\"C\"&COLUMN()+3)","v":89},{"$f":"INDIRECT(\"C\"&COLUMN()+3)","v":78},{"$f":"INDIRECT(\"C\"&COLUMN()+3)","v":67},{"$f":"INDIRECT(\"C\"&COLUMN()+3)","v":84},{"$f":"INDIRECT(\"C\"&COLUMN()+3)","v":78}]
[null,{"$f":"INDIRECT(\"D\"&COLUMN()+3)","v":"Chemistry"},{"$f":"INDIRECT(\"D\"&COLUMN()+3)","v":87},{"$f":"INDIRECT(\"D\"&COLUMN()+3)","v":76},{"$f":"INDIRECT(\"D\"&COLUMN()+3)","v":65},{"$f":"INDIRECT(\"D\"&COLUMN()+3)","v":89},{"$f":"INDIRECT(\"D\"&COLUMN()+3)","v":63},{"$f":"INDIRECT(\"D\"&COLUMN()+3)","v":87}]
[null,{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":"Math"},{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":68},{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":91},{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":75},{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":75},{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":85},{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":91}]

{"sheet":"Indirect & Address","index":4,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,14,2,17]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Physics","Chemistry","Math",null,null,null,null,null,null,null,null,null,"Name","Physics","Chemistry","Math"]
[null,"Matt",77,87,68,null,null,null,null,null,null,null,null,null,"Matt",77,87,68]
[null,"Emma",89,76,91,null,null,null,null,null,null,null,null,null,"Emma",89,76,91]
[null,"Milly",78,65,75,null,null,null,null,null,null,null,null,null,"Milly",78,65,75]
[null,"Olivia",67,89,75,null,null,null,null,null,null,null,null,null,"Olivia",67,89,75]
[null,"Emily",84,63,85,null,null,null,null,null,null,null,null,null,"Emily",84,63,85]
[null,"Paddy",78,87,91,null,null,null,null,null,null,null,null,null,"Paddy",78,87,91]
[]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B5) - COLUMN($B$5) + ROW($B$5), ROW(B5) - ROW($B$5) + COLUMN($B$5)))","v":"Name"},{"$f":"INDIRECT(ADDRESS(COLUMN(C5) - COLUMN($B$5) + ROW($B$5), ROW(C5) - ROW($B$5) + COLUMN($B$5)))","v":"Matt"},{"$f":"INDIRECT(ADDRESS(COLUMN(D5) - COLUMN($B$5) + ROW($B$5), ROW(D5) - ROW($B$5) + COLUMN($B$5)))","v":"Emma"},{"$f":"INDIRECT(ADDRESS(COLUMN(E5) - COLUMN($B$5) + ROW($B$5), ROW(E5) - ROW($B$5) + COLUMN($B$5)))","v":"Milly"},{"$f":"INDIRECT(ADDRESS(COLUMN(F5) - COLUMN($B$5) + ROW($B$5), ROW(F5) - ROW($B$5) + COLUMN($B$5)))","v":"Olivia"},{"$f":"INDIRECT(ADDRESS(COLUMN(G5) - COLUMN($B$5) + ROW($B$5), ROW(G5) - ROW($B$5) + COLUMN($B$5)))","v":"Emily"},{"$f":"INDIRECT(ADDRESS(COLUMN(H5) - COLUMN($B$5) + ROW($B$5), ROW(H5) - ROW($B$5) + COLUMN($B$5)))","v":"Paddy"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B6) - COLUMN($B$5) + ROW($B$5), ROW(B6) - ROW($B$5) + COLUMN($B$5)))","v":"Physics"},{"$f":"INDIRECT(ADDRESS(COLUMN(C6) - COLUMN($B$5) + ROW($B$5), ROW(C6) - ROW($B$5) + COLUMN($B$5)))","v":77},{"$f":"INDIRECT(ADDRESS(COLUMN(D6) - COLUMN($B$5) + ROW($B$5), ROW(D6) - ROW($B$5) + COLUMN($B$5)))","v":89},{"$f":"INDIRECT(ADDRESS(COLUMN(E6) - COLUMN($B$5) + ROW($B$5), ROW(E6) - ROW($B$5) + COLUMN($B$5)))","v":78},{"$f":"INDIRECT(ADDRESS(COLUMN(F6) - COLUMN($B$5) + ROW($B$5), ROW(F6) - ROW($B$5) + COLUMN($B$5)))","v":67},{"$f":"INDIRECT(ADDRESS(COLUMN(G6) - COLUMN($B$5) + ROW($B$5), ROW(G6) - ROW($B$5) + COLUMN($B$5)))","v":84},{"$f":"INDIRECT(ADDRESS(COLUMN(H6) - COLUMN($B$5) + ROW($B$5), ROW(H6) - ROW($B$5) + COLUMN($B$5)))","v":78}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B7) - COLUMN($B$5) + ROW($B$5), ROW(B7) - ROW($B$5) + COLUMN($B$5)))","v":"Chemistry"},{"$f":"INDIRECT(ADDRESS(COLUMN(C7) - COLUMN($B$5) + ROW($B$5), ROW(C7) - ROW($B$5) + COLUMN($B$5)))","v":87},{"$f":"INDIRECT(ADDRESS(COLUMN(D7) - COLUMN($B$5) + ROW($B$5), ROW(D7) - ROW($B$5) + COLUMN($B$5)))","v":76},{"$f":"INDIRECT(ADDRESS(COLUMN(E7) - COLUMN($B$5) + ROW($B$5), ROW(E7) - ROW($B$5) + COLUMN($B$5)))","v":65},{"$f":"INDIRECT(ADDRESS(COLUMN(F7) - COLUMN($B$5) + ROW($B$5), ROW(F7) - ROW($B$5) + COLUMN($B$5)))","v":89},{"$f":"INDIRECT(ADDRESS(COLUMN(G7) - COLUMN($B$5) + ROW($B$5), ROW(G7) - ROW($B$5) + COLUMN($B$5)))","v":63},{"$f":"INDIRECT(ADDRESS(COLUMN(H7) - COLUMN($B$5) + ROW($B$5), ROW(H7) - ROW($B$5) + COLUMN($B$5)))","v":87}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B8) - COLUMN($B$5) + ROW($B$5), ROW(B8) - ROW($B$5) + COLUMN($B$5)))","v":"Math"},{"$f":"INDIRECT(ADDRESS(COLUMN(C8) - COLUMN($B$5) + ROW($B$5), ROW(C8) - ROW($B$5) + COLUMN($B$5)))","v":68},{"$f":"INDIRECT(ADDRESS(COLUMN(D8) - COLUMN($B$5) + ROW($B$5), ROW(D8) - ROW($B$5) + COLUMN($B$5)))","v":91},{"$f":"INDIRECT(ADDRESS(COLUMN(E8) - COLUMN($B$5) + ROW($B$5), ROW(E8) - ROW($B$5) + COLUMN($B$5)))","v":75},{"$f":"INDIRECT(ADDRESS(COLUMN(F8) - COLUMN($B$5) + ROW($B$5), ROW(F8) - ROW($B$5) + COLUMN($B$5)))","v":75},{"$f":"INDIRECT(ADDRESS(COLUMN(G8) - COLUMN($B$5) + ROW($B$5), ROW(G8) - ROW($B$5) + COLUMN($B$5)))","v":85},{"$f":"INDIRECT(ADDRESS(COLUMN(H8) - COLUMN($B$5) + ROW($B$5), ROW(H8) - ROW($B$5) + COLUMN($B$5)))","v":91}]

{"sheet":"Index Function","index":5,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,14,2,17]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Physics","Chemistry","Math",null,null,null,null,null,null,null,null,null,"Name","Physics","Chemistry","Math"]
[null,"Matt",77,87,68,null,null,null,null,null,null,null,null,null,"Matt",77,87,68]
[null,"Emma",89,76,91,null,null,null,null,null,null,null,null,null,"Emma",89,76,91]
[null,"Milly",78,65,75,null,null,null,null,null,null,null,null,null,"Milly",78,65,75]
[null,"Olivia",67,89,75,null,null,null,null,null,null,null,null,null,"Olivia",67,89,75]
[null,"Emily",84,63,85,null,null,null,null,null,null,null,null,null,"Emily",84,63,85]
[null,"Paddy",78,87,91,null,null,null,null,null,null,null,null,null,"Paddy",78,87,91]
[]
[null,{"$f":"INDEX($B$5:$E$11,COLUMN()-1,1)","v":"Name"},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,1)","v":"Matt"},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,1)","v":"Emma"},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,1)","v":"Milly"},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,1)","v":"Olivia"},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,1)","v":"Emily"},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,1)","v":"Paddy"}]
[null,{"$f":"INDEX($B$5:$E$11,COLUMN()-1,2)","v":"Physics"},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,2)","v":77},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,2)","v":89},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,2)","v":78},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,2)","v":67},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,2)","v":84},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,2)","v":78}]
[null,{"$f":"INDEX($B$5:$E$11,COLUMN()-1,3)","v":"Chemistry"},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,3)","v":87},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,3)","v":76},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,3)","v":65},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,3)","v":89},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,3)","v":63},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,3)","v":87}]
[null,{"$f":"INDEX($B$5:$E$11,COLUMN()-1,4)","v":"Math"},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,4)","v":68},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,4)","v":91},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,4)","v":75},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,4)","v":75},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,4)","v":85},{"$f":"INDEX($B$5:$E$11,COLUMN()-1,4)","v":91}]

{"sheet":"Table1","index":6,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Column1","Column2","Column3","Column4","Column5","Column6"]
["Matt","Emma","Milly","Olivia","Emily","Paddy"]
[77,89,78,67,84,78]
[87,76,65,89,63,87]
[68,91,75,75,85,91]

{"sheet":"Ribbon","index":7,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,8,2,11]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Physics","Chemistry","Math",null,null,null,"Name","Physics","Chemistry","Math"]
[null,"Matt",77,87,68,null,null,null,"Matt",77,87,68]
[null,"Emma",89,76,91,null,null,null,"Emma",89,76,91]
[null,"Milly",78,65,75,null,null,null,"Milly",78,65,75]
[null,"Olivia",67,89,75,null,null,null,"Olivia",67,89,75]
[null,"Emily",84,63,85,null,null,null,"Emily",84,63,85]
[null,"Paddy",78,87,91,null,null,null,"Paddy",78,87,91]

{"sheet":"Transpose table with link","index":8,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,11,2,14]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Physics","Chemistry","Math",null,"xxxB5","xxxC5","xxxD5","xxxE5",null,"Name","Physics","Chemistry","Math"]
[null,"Matt",77,87,68,null,"xxxB6","xxxC6","xxxD6","xxxE6",null,"Matt",77,87,68]
[null,"Emma",89,76,91,null,"xxxB7","xxxC7","xxxD7","xxxE7",null,"Emma",89,76,91]
[null,"Milly",78,65,75,null,"xxxB8","xxxC8","xxxD8","xxxE8",null,"Milly",78,65,75]
[null,"Olivia",67,89,75,null,"xxxB9","xxxC9","xxxD9","xxxE9",null,"Olivia",67,89,75]
[null,"Emily",84,63,85,null,"xxxB10","xxxC10","xxxD10","xxxE10",null,"Emily",84,63,85]
[null,"Paddy",78,87,91,null,"xxxB11","xxxC11","xxxD11","xxxE11",null,"Paddy",78,87,91]
[]
[null,{"$f":"B5","v":"Name"},{"$f":"B6","v":"Matt"},{"$f":"B7","v":"Emma"},{"$f":"B8","v":"Milly"},{"$f":"B9","v":"Olivia"},{"$f":"B10","v":"Emily"},{"$f":"B11","v":"Paddy"}]
[null,{"$f":"C5","v":"Physics"},{"$f":"C6","v":77},{"$f":"C7","v":89},{"$f":"C8","v":78},{"$f":"C9","v":67},{"$f":"C10","v":84},{"$f":"C11","v":78}]
[null,{"$f":"D5","v":"Chemistry"},{"$f":"D6","v":87},{"$f":"D7","v":76},{"$f":"D8","v":65},{"$f":"D9","v":89},{"$f":"D10","v":63},{"$f":"D11","v":87}]
[null,{"$f":"E5","v":"Math"},{"$f":"E6","v":68},{"$f":"E7","v":91},{"$f":"E8","v":75},{"$f":"E9","v":75},{"$f":"E10","v":85},{"$f":"E11","v":91}]

{"sheet":"VBA","index":9,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,14,2,17]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Physics","Chemistry","Math",null,null,null,null,null,null,null,null,null,"Name","Physics","Chemistry","Math"]
[null,"Matt",77,87,68,null,null,null,null,null,null,null,null,null,"Matt",77,87,68]
[null,"Emma",89,76,91,null,null,null,null,null,null,null,null,null,"Emma",89,76,91]
[null,"Milly",78,65,75,null,null,null,null,null,null,null,null,null,"Milly",78,65,75]
[null,"Olivia",67,89,75,null,null,null,null,null,null,null,null,null,"Olivia",67,89,75]
[null,"Emily",84,63,85,null,null,null,null,null,null,null,null,null,"Emily",84,63,85]
[null,"Paddy",78,87,91,null,null,null,null,null,null,null,null,null,"Paddy",78,87,91]
[]
[null,"Name","Matt","Emma","Milly","Olivia","Emily","Paddy"]
[null,"Physics",77,89,78,67,84,78]
[null,"Chemistry",87,76,65,89,63,87]
[null,"Math",68,91,75,75,85,91]