{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sample Data Set","Paste Special Command","TRANSPOSE Function","VBA Code","INDIRECT_ADDRESS Function"],"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":"Sample Data Set","index":0,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sample Data Set"]
[]
[null,"Student Name","John","Caroline ","Mike","Jill","Robert"]
[null,"Physics",70,78,96,64,65]
[null,"Chemistry",76,87,69,91,95]
[null,"Maths",83,98,73,66,80]
[null,"English",65,85,87,88,61]
[null,"Biology",90,65,62,72,69]

{"sheet":"Paste Special Command","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[10,1,10,6],[1,1,1,6]]}
[]
[null,"Using Paste Special Command"]
[]
[null,"Student Name","John","Caroline ","Mike","Jill","Robert"]
[null,"Physics",70,78,96,64,65]
[null,"Chemistry",76,87,69,91,95]
[null,"Maths",83,98,73,66,80]
[null,"English",65,85,87,88,61]
[null,"Biology",90,65,62,72,69]
[]
[null,"Results"]
[null,"Student Name","Physics","Chemistry","Maths","English","Biology"]
[null,"John",70,76,83,65,90]
[null,"Caroline ",78,87,98,85,65]
[null,"Mike",96,69,73,87,62]
[null,"Jill",64,91,66,88,72]
[null,"Robert",65,95,80,61,69]

{"sheet":"TRANSPOSE Function","index":2,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6],[10,1,10,6]]}
[]
[null," Utilizing TRANSPOSE Function"]
[]
[null,"Student Name","John","Caroline ","Mike","Jill","Robert"]
[null,"Physics",70,78,96,64,65]
[null,"Chemistry",76,87,69,91,95]
[null,"Maths",83,98,73,66,80]
[null,"English",65,85,87,88,61]
[null,"Biology",90,65,62,72,69]
[]
[null,"Results"]
[null,{"$f":"TRANSPOSE(B4:G9)","v":"Student Name"},"Physics","Chemistry","Maths","English","Biology"]
[null,"John",70,76,83,65,90]
[null,"Caroline ",78,87,98,85,65]
[null,"Mike",96,69,73,87,62]
[null,"Jill",64,91,66,88,72]
[null,"Robert",65,95,80,61,69]

{"sheet":"VBA Code","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6],[10,1,10,6]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Student Name","John","Caroline ","Mike","Jill","Robert"]
[null,"Physics",70,78,96,64,65]
[null,"Chemistry",76,87,69,91,95]
[null,"Maths",83,98,73,66,80]
[null,"English",65,85,87,88,61]
[null,"Biology",90,65,62,72,69]
[]
[null,"Results"]
[null,"Student Name","Physics","Chemistry","Maths","English","Biology"]
[null,"John",70,76,83,65,90]
[null,"Caroline ",78,87,98,85,65]
[null,"Mike",96,69,73,87,62]
[null,"Jill",64,91,66,88,72]
[null,"Robert",65,95,80,61,69]

{"sheet":"INDIRECT_ADDRESS Function","index":4,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6],[10,1,10,6]]}
[]
[null,"Using INDIRECT and ADDRESS Functions "]
[]
[null,"Student Name","John","Caroline ","Mike","Jill","Robert"]
[null,"Physics",70,78,96,64,65]
[null,"Chemistry",76,87,69,91,95]
[null,"Maths",83,98,73,66,80]
[null,"English",65,85,87,88,61]
[null,"Biology",90,65,62,72,69]
[]
[null,"Results"]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B4)-COLUMN($B$4)+ROW($B$4),ROW(B4)-ROW($B$4)+COLUMN($B$4)))","v":"Student Name"},{"$f":"INDIRECT(ADDRESS(COLUMN(C4)-COLUMN($B$4)+ROW($B$4),ROW(C4)-ROW($B$4)+COLUMN($B$4)))","v":"Physics"},"Chemistry","Maths","English","Biology"]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B5)-COLUMN($B$4)+ROW($B$4),ROW(B5)-ROW($B$4)+COLUMN($B$4)))","v":"John"},70,76,83,65,90]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B6)-COLUMN($B$4)+ROW($B$4),ROW(B6)-ROW($B$4)+COLUMN($B$4)))","v":"Caroline "},78,87,98,85,65]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B7)-COLUMN($B$4)+ROW($B$4),ROW(B7)-ROW($B$4)+COLUMN($B$4)))","v":"Mike"},96,69,73,87,62]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B8)-COLUMN($B$4)+ROW($B$4),ROW(B8)-ROW($B$4)+COLUMN($B$4)))","v":"Jill"},64,91,66,88,72]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B9)-COLUMN($B$4)+ROW($B$4),ROW(B9)-ROW($B$4)+COLUMN($B$4)))","v":"Robert"},65,95,80,61,69]