{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["1784C","WRAPCOLS SORTBY","WRAPCOLS SORTBY (an)","1785C","TOCOL DROP","TOCOL DROP(an)","Test"],"not_rendered":{"charts":0,"images":7,"macros":0,"external_links":0,"defined_names":62,"comments":0,"pivot_tables":2},"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":"1784C","index":0,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,1,10,7],[11,1,14,9],[25,1,29,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Excel Magic Trick 1784"]
[]
[]
[]
[]
[null,"Excel Statistical Analysis 7: Cross Tabulation, Visualizations, AND Logical Tests, Simpson’s Paradox"]
[null,{"$f":"LEN(B17)","v":100}]
[null,null,{"$f":"LEN(C18)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TOCOL & DROP Functions"]
[null,null,null,null,null,null,null,"Microsoft 365 Excel",null,null,null,"or"]
[null,null,null,null,null,null,null,null,null,null,null,"Power Query UnPivot?"]
[]
[null,"WRAPCOL & SORTBY Functions\nFormula to Pivot"]

{"sheet":"WRAPCOLS SORTBY","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"WRAPCOLS and WRAPROWS functions opposite of TOCOL and TOROW",null,null,null,null,"Count Students:",null,{"$f":"ROWS(_xlfn.UNIQUE(ProperTable[Names]))","v":5}]
[]
[null,"Names","Quiz","Quize Scores",null,"Student/Quiz",{"$f":"TRANSPOSE(_xlfn.UNIQUE(C5:C19))","v":"Quiz 1"},"Quiz 2","Quiz 3"]
[null,"Chantel","Quiz 1",9,null,{"$f":"_xlfn.UNIQUE(B5:B19)","v":"Chantel"},{"$f":"_xlfn.WRAPCOLS(D5:D19,5)","v":9},10,4]
[null,"Devonte","Quiz 1",5,null,"Devonte",5,3,6]
[null,"June","Quiz 1",5,null,"June",5,4,2]
[null,"Sioux","Quiz 1",2,null,"Sioux",2,10,9]
[null,"Timmy","Quiz 1",10,null,"Timmy",10,4,8]
[null,"Chantel","Quiz 2",10]
[null,"Devonte","Quiz 2",3]
[null,"June","Quiz 2",4,null,"Student/Quiz"]
[null,"Sioux","Quiz 2",10]
[null,"Timmy","Quiz 2",4]
[null,"Chantel","Quiz 3",4]
[null,"Devonte","Quiz 3",6]
[null,"June","Quiz 3",2]
[null,"Sioux","Quiz 3",9]
[null,"Timmy","Quiz 3",8,null,"Student/Quiz",{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.SORT(ProperTable[Quiz])))","v":"Quiz 1"},"Quiz 2","Quiz 3"]
[null,null,null,null,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(ProperTable[Names]))","v":"Chantel"},{"$f":"_xlfn.XLOOKUP(G$19&$F20,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":9},{"$f":"_xlfn.XLOOKUP(H$19&$F20,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":10},{"$f":"_xlfn.XLOOKUP(I$19&$F20,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":4}]
[null,null,null,null,null,"Devonte",{"$f":"_xlfn.XLOOKUP(G$19&$F21,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":5},{"$f":"_xlfn.XLOOKUP(H$19&$F21,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":3},{"$f":"_xlfn.XLOOKUP(I$19&$F21,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":6}]
[null,null,null,null,null,"June",{"$f":"_xlfn.XLOOKUP(G$19&$F22,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":5},{"$f":"_xlfn.XLOOKUP(H$19&$F22,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":4},{"$f":"_xlfn.XLOOKUP(I$19&$F22,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":2}]
[null,null,null,null,null,"Sioux",{"$f":"_xlfn.XLOOKUP(G$19&$F23,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":2},{"$f":"_xlfn.XLOOKUP(H$19&$F23,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":10},{"$f":"_xlfn.XLOOKUP(I$19&$F23,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":9}]
[null,null,null,null,null,"Timmy",{"$f":"_xlfn.XLOOKUP(G$19&$F24,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":10},{"$f":"_xlfn.XLOOKUP(H$19&$F24,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":4},{"$f":"_xlfn.XLOOKUP(I$19&$F24,ProperTable[[Quiz]:[Quiz]]&ProperTable[[Names]:[Names]],ProperTable[[Quize Scores]:[Quize Scores]])","v":8}]
[]
[null,null,null,null,null,"ListQuizzes","Quiz"]
[null,null,null,null,null,"Names","Quiz 1","Quiz 2","Quiz 3"]
[null,null,null,null,null,"June",5,4,2]
[null,null,null,null,null,"Chantel",9,10,4]
[null,null,null,null,null,"Devonte",5,3,6]
[null,null,null,null,null,"Sioux",2,10,9]
[null,null,null,null,null,"Timmy",10,4,8]

{"sheet":"WRAPCOLS SORTBY (an)","index":2,"n_rows":40,"n_cols":22,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"WRAPCOLS and WRAPROWS functions opposite of TOCOL and TOROW",null,null,null,null,"Count Students:",null,{"$f":"ROWS(_xlfn.UNIQUE(ProperTableAnswer[Names]))","v":5}]
[]
[null,"Names","Quiz","Quize Scores",null,"Student/Quiz",{"$f":"TRANSPOSE(_xlfn.UNIQUE(C5:C19))","v":"Quiz 1"},"Quiz 2","Quiz 3"]
[null,"Chantel","Quiz 1",9,null,{"$f":"_xlfn.UNIQUE(B5:B19)","v":"Chantel"},{"$f":"_xlfn.WRAPCOLS(D5:D19,5)","v":9},10,4]
[null,"Devonte","Quiz 1",5,null,"Devonte",5,3,6]
[null,"June","Quiz 1",5,null,"June",5,4,2]
[null,"Sioux","Quiz 1",2,null,"Sioux",2,10,9]
[null,"Timmy","Quiz 1",10,null,"Timmy",10,4,8]
[null,"Chantel","Quiz 2",10]
[null,"Devonte","Quiz 2",3]
[null,"June","Quiz 2",4,null,"Student/Quiz",{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.SORT(ProperTableAnswer[Quiz])))","v":"Quiz 1"},"Quiz 2","Quiz 3"]
[null,"Sioux","Quiz 2",10,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(ProperTableAnswer[Names]))","v":"Chantel"},{"$f":"_xlfn.WRAPCOLS(_xlfn.SORTBY(ProperTableAnswer[Quize Scores],ProperTableAnswer[Quiz],,ProperTableAnswer[Names],),I2)","v":9},10,4]
[null,"Timmy","Quiz 2",4,null,"Devonte",5,3,6]
[null,"Chantel","Quiz 3",4,null,"June",5,4,2]
[null,"Devonte","Quiz 3",6,null,"Sioux",2,10,9,null,{"$f":"_xlfn.SORTBY(ProperTableAnswer[Quize Scores],ProperTableAnswer[Quiz],,ProperTableAnswer[Names],)","v":9},null,null,"Excel Wizard:",null,null,null,null,"Giovanni Vitulli solution:"]
[null,"June","Quiz 3",2,null,"Timmy",10,4,8,null,5]
[null,"Sioux","Quiz 3",9,null,null,null,null,null,null,5,null,null,{"$f":"_xlfn.LET(_xlpm.z,ProperTable[],_xlpm.sz,_xlfn._xlws.SORT(_xlpm.z,{2,1}),_xlpm.un,_xlfn.UNIQUE(_xlfn.TAKE(_xlpm.sz,,1)),_xlpm.uq,TRANSPOSE(_xlfn.UNIQUE(INDEX(_xlpm.sz,,2))),_xlfn.HSTACK(_xlfn.VSTACK(\"Student/Quiz\",_xlpm.un),_xlfn.VSTACK(_xlpm.uq,_xlfn.WRAPCOLS(INDEX(_xlpm.sz,,3),ROWS(_xlpm.un)))))","v":"Student/Quiz"},"Quiz 1","Quiz 2","Quiz 3",null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.SORT(ProperTableAnswer[Quiz])))","v":"Quiz 1"},"Quiz 2","Quiz 3"]
[null,"Timmy","Quiz 3",8,null,"Student/Quiz",{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.SORT(ProperTableAnswer[Quiz])))","v":"Quiz 1"},"Quiz 2","Quiz 3",null,2,null,null,"Chantel",9,10,4,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(ProperTableAnswer[Names]))","v":"Chantel"},{"$f":"INDEX(ProperTable[Quize Scores], _xlfn.XMATCH(_xlfn.ANCHORARRAY(S19)&_xlfn.ANCHORARRAY(T18),ProperTable[Names]&ProperTable[Quiz]))","v":9},10,4]
[null,null,null,null,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(ProperTableAnswer[Names]))","v":"Chantel"},{"$f":"_xlfn.XLOOKUP(G$19&$F20,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":9},{"$f":"_xlfn.XLOOKUP(H$19&$F20,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":10},{"$f":"_xlfn.XLOOKUP(I$19&$F20,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":4},null,10,null,null,"Devonte",5,3,6,null,"Devonte",5,3,6]
[null,null,null,null,null,"Devonte",{"$f":"_xlfn.XLOOKUP(G$19&$F21,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":5},{"$f":"_xlfn.XLOOKUP(H$19&$F21,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":3},{"$f":"_xlfn.XLOOKUP(I$19&$F21,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":6},null,10,null,null,"June",5,4,2,null,"June",5,4,2]
[null,null,null,null,null,"June",{"$f":"_xlfn.XLOOKUP(G$19&$F22,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":5},{"$f":"_xlfn.XLOOKUP(H$19&$F22,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":4},{"$f":"_xlfn.XLOOKUP(I$19&$F22,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":2},null,3,null,null,"Sioux",2,10,9,null,"Sioux",2,10,9]
[null,null,null,null,null,"Sioux",{"$f":"_xlfn.XLOOKUP(G$19&$F23,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":2},{"$f":"_xlfn.XLOOKUP(H$19&$F23,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":10},{"$f":"_xlfn.XLOOKUP(I$19&$F23,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":9},null,4,null,null,"Timmy",10,4,8,null,"Timmy",10,4,8]
[null,null,null,null,null,"Timmy",{"$f":"_xlfn.XLOOKUP(G$19&$F24,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":10},{"$f":"_xlfn.XLOOKUP(H$19&$F24,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":4},{"$f":"_xlfn.XLOOKUP(I$19&$F24,ProperTableAnswer[[Quiz]:[Quiz]]&ProperTableAnswer[[Names]:[Names]],ProperTableAnswer[[Quize Scores]:[Quize Scores]])","v":8},null,10]
[null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,"ListQuizzes","Quiz",null,null,null,4,null,null,"anthony lecoq:"]
[null,null,null,null,null,"Names","Quiz 1","Quiz 2","Quiz 3",null,6,null,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.SORT(ProperTableAnswer[Quiz])))","v":"Quiz 1"},"Quiz 2","Quiz 3"]
[null,null,null,null,null,"June",5,4,2,null,2,null,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(ProperTableAnswer[Names]))","v":"Chantel"},{"$f":"SUMIFS(ProperTableAnswer[Quize Scores],ProperTableAnswer[Quiz],_xlfn.ANCHORARRAY(O27),ProperTableAnswer[Names],_xlfn.ANCHORARRAY(N28))","v":9},10,4]
[null,null,null,null,null,"Chantel",9,10,4,null,9,null,null,"Devonte",5,3,6]
[null,null,null,null,null,"Devonte",5,3,6,null,8,null,null,"June",5,4,2]
[null,null,null,null,null,"Sioux",2,10,9,null,null,null,null,"Sioux",2,10,9]
[null,null,null,null,null,"Timmy",10,4,8,null,null,null,null,"Timmy",10,4,8]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ExcelLambda:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.LAMBDA(_xlpm.r,_xlpm.c,_xlpm.v,_xlop.cs,_xlop.t, _xlfn.LET( _xlpm.u,_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlpm.r)),_xlpm.q,_xlfn.TOROW(_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlpm.c))), _xlpm.w,ROWS(_xlpm.u),_xlpm.l,COLUMNS(_xlpm.q), _xlpm.m,_xlfn.MAP( REPT(_xlpm.u,_xlfn.SEQUENCE(,_xlpm.l)^0), REPT(_xlpm.q,_xlfn.SEQUENCE(_xlpm.w)^0), _xlfn.LAMBDA(_xlpm.a,_xlpm.b,SUM((_xlpm.a=_xlpm.r)*(_xlpm.b=_xlpm.c)*IF(_xlpm.cs,1,_xlpm.v))) ), _xlfn.VSTACK(_xlfn.HSTACK(IF(_xlfn.ISOMITTED(_xlpm.t),\"\",_xlpm.t),_xlpm.q),_xlfn.HSTACK(_xlpm.u,_xlpm.m)) ) )(ProperTableAnswer[Names],ProperTableAnswer[Quiz],ProperTableAnswer[Quize Scores],,ProperTableAnswer[[#Headers],[Names]]&\"/\"&ProperTableAnswer[[#Headers],[Quiz]])","v":"Names/Quiz"},"Quiz 1","Quiz 2","Quiz 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Chantel",9,10,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Devonte",5,3,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"June",5,4,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sioux",2,10,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Timmy",10,4,8]

{"sheet":"1785C","index":3,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[11,1,14,9],[6,1,10,7],[25,1,29,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Excel Magic Trick 1785"]
[]
[]
[]
[]
[null,"Excel Statistical Analysis 7: Cross Tabulation, Visualizations, AND Logical Tests, Simpson’s Paradox"]
[null,{"$f":"LEN(B17)","v":100}]
[null,null,{"$f":"LEN(C18)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TOCOL & DROP Functions"]
[null,null,null,null,null,null,null,"Microsoft 365 Excel",null,null,null,"or"]
[null,null,null,null,null,null,null,null,null,null,null,"Power Query UnPivot?"]
[]
[null,"TOCOL, DROP, EXPAND Functions\nFormula to UnPivot"]

{"sheet":"TOCOL DROP","index":4,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"Dynamic Array Formula with TOCOL and DROP and more:"]
[]
[null,"Student/Quiz","Quiz 1","Quiz 2","Quiz 3","Quiz 4",null,null,"Student","Quiz","Score"]
[null,"Chantel",9,10,4,10]
[null,"Devonte",5,3,6,9]
[null,"June",5,4,2,6]
[null,"Sioux",2,10,9,9]
[null,"Timmy",10,4,8,2]
[null,"You",10,10,10,10]

{"sheet":"TOCOL DROP(an)","index":5,"n_rows":47,"n_cols":40,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"Dynamic Array Formula with TOCOL and DROP:",null,null,null,null,"Power Query:",null,null,null,"Old School:",null,null,null,"Mod Version:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LET only:",null,null,null,"Lambda in cell:",null,null,null,"Defined Name:"]
[null,"Student/Quiz","Quiz 1","Quiz 2","Quiz 3",null,null,null,"Student","Quiz","Score",null,null,"Student","Quiz","Score",null,"Student","Quiz","Score",null,"Quiz",null,{"$f":"_xlfn.LET(\n_xlpm.TableAll,QuizCrossTabAnswer[#All],\n_xlpm.r,ROWS(_xlpm.TableAll)-1,_xlpm.c,COLUMNS(_xlpm.TableAll)-1,_xlpm.s,_xlfn.SEQUENCE(_xlpm.r*_xlpm.c),\n_xlpm.q,QUOTIENT(_xlpm.s-1,_xlpm.c)+2,_xlpm.m,MOD(_xlpm.s-1,_xlpm.c)+2,\n_xlfn.VSTACK({\"Student\",\"Quiz\",\"Score\"},_xlfn.HSTACK(INDEX(_xlfn.TAKE(_xlpm.TableAll,,1),_xlpm.q),INDEX(_xlfn.TAKE(_xlpm.TableAll,1),_xlpm.m),_xlfn.TOCOL(_xlfn.DROP(_xlpm.TableAll,1,1)))))","v":"Student"},"Quiz","Score",null,{"$f":"_xlfn.LAMBDA(_xlpm.TableAll,_xlop.TextHeaders,\n_xlfn.LET(\n_xlpm.a,_xlpm.TableAll,\n_xlpm.r,ROWS(_xlpm.a)-1,_xlpm.c,COLUMNS(_xlpm.a)-1,_xlpm.s,_xlfn.SEQUENCE(_xlpm.r*_xlpm.c),\n_xlpm.q,QUOTIENT(_xlpm.s-1,_xlpm.c)+2,_xlpm.m,MOD(_xlpm.s-1,_xlpm.c)+2,\n_xlpm.h,_xlfn.HSTACK(INDEX(_xlfn.TAKE(_xlpm.a,,1),_xlpm.q),INDEX(_xlfn.TAKE(_xlpm.a,1),_xlpm.m),_xlfn.TOCOL(_xlfn.DROP(_xlpm.a,1,1))),\nIF(_xlfn.ISOMITTED(_xlpm.TextHeaders),_xlpm.h,_xlfn.VSTACK(_xlpm.TextHeaders,_xlpm.h))))(QuizCrossTabAnswer[#All])","v":"Chantel"},"Quiz 1",9,null,{"$f":"UnPivot(QuizCrossTabAnswer[#All],{\"Student\",\"Quiz\",\"Score\"})","v":"Student"},"Quiz","Score"]
[null,"Chantel",9,10,4,null,null,null,{"$f":"_xlfn.LET(\n_xlpm.qn,_xlfn.DROP(QuizCrossTabAnswer[#Headers],,1),_xlpm.sn,QuizCrossTabAnswer[Student/Quiz],\n_xlpm.qc,COLUMNS(_xlpm.qn),_xlpm.sc,ROWS(_xlpm.sn),\nINDEX(_xlpm.sn,ROUNDUP(_xlfn.SEQUENCE(_xlpm.qc*_xlpm.sc)/_xlpm.qc,0)))","v":"Chantel"},{"$f":"_xlfn.LET(\n_xlpm.qn,_xlfn.DROP(QuizCrossTabAnswer[#Headers],,1),_xlpm.sn,QuizCrossTabAnswer[Student/Quiz],\n_xlfn.TOCOL(_xlfn.IFNA(_xlfn.EXPAND(_xlpm.qn,ROWS(_xlpm.sn)),_xlpm.qn)))","v":"Quiz 1"},{"$f":"_xlfn.TOCOL(_xlfn.DROP(QuizCrossTabAnswer[],,1))","v":9},null,null,"Chantel","Quiz 1",9,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R5)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"Chantel"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S5)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 1"},{"$f":"VLOOKUP(R5,QuizCrossTabAnswer[],MATCH(S5,QuizCrossTabAnswer[#Headers],0))","v":9},null,{"$f":"_xlfn.LET(\n_xlpm.qn,_xlfn.DROP(QuizCrossTabAnswer[#Headers],,1),_xlpm.sn,QuizCrossTabAnswer[Student/Quiz],\n_xlpm.qc,COLUMNS(_xlpm.qn),_xlpm.sc,ROWS(_xlpm.sn),\nINDEX(_xlpm.qn,MOD(_xlfn.SEQUENCE(_xlpm.qc*_xlpm.sc,,0),_xlpm.qc)+1))","v":"Quiz 1"},null,"Chantel","Quiz 1",9,null,"Chantel","Quiz 2",10,null,"Chantel","Quiz 1",9]
[null,"Devonte",5,3,6,null,null,null,"Chantel","Quiz 2",10,null,null,"Chantel","Quiz 2",10,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R6)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"Chantel"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S6)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 2"},{"$f":"VLOOKUP(R6,QuizCrossTabAnswer[],MATCH(S6,QuizCrossTabAnswer[#Headers],0))","v":10},null,"Quiz 2",null,"Chantel","Quiz 2",10,null,"Chantel","Quiz 3",4,null,"Chantel","Quiz 2",10]
[null,"June",5,4,2,null,null,null,"Chantel","Quiz 3",4,null,null,"Chantel","Quiz 3",4,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R7)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"Chantel"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S7)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 3"},{"$f":"VLOOKUP(R7,QuizCrossTabAnswer[],MATCH(S7,QuizCrossTabAnswer[#Headers],0))","v":4},null,"Quiz 3",null,"Chantel","Quiz 3",4,null,"Devonte","Quiz 1",5,null,"Chantel","Quiz 3",4]
[null,"Sioux",2,10,9,null,null,null,"Devonte","Quiz 1",5,null,null,"Devonte","Quiz 1",5,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R8)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"Devonte"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S8)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 1"},{"$f":"VLOOKUP(R8,QuizCrossTabAnswer[],MATCH(S8,QuizCrossTabAnswer[#Headers],0))","v":5},null,"Quiz 1",null,"Devonte","Quiz 1",5,null,"Devonte","Quiz 2",3,null,"Devonte","Quiz 1",5]
[null,"Timmy",10,4,8,null,null,null,"Devonte","Quiz 2",3,null,null,"Devonte","Quiz 2",3,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R9)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"Devonte"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S9)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 2"},{"$f":"VLOOKUP(R9,QuizCrossTabAnswer[],MATCH(S9,QuizCrossTabAnswer[#Headers],0))","v":3},null,"Quiz 2",null,"Devonte","Quiz 2",3,null,"Devonte","Quiz 3",6,null,"Devonte","Quiz 2",3]
[null,null,null,null,null,null,null,null,"Devonte","Quiz 3",6,null,null,"Devonte","Quiz 3",6,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R10)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"Devonte"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S10)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 3"},{"$f":"VLOOKUP(R10,QuizCrossTabAnswer[],MATCH(S10,QuizCrossTabAnswer[#Headers],0))","v":6},null,"Quiz 3",null,"Devonte","Quiz 3",6,null,"June","Quiz 1",5,null,"Devonte","Quiz 3",6]
[null,null,null,null,null,null,null,null,"June","Quiz 1",5,null,null,"June","Quiz 1",5,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R11)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"June"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S11)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 1"},{"$f":"VLOOKUP(R11,QuizCrossTabAnswer[],MATCH(S11,QuizCrossTabAnswer[#Headers],0))","v":5},null,"Quiz 1",null,"June","Quiz 1",5,null,"June","Quiz 2",4,null,"June","Quiz 1",5]
[null,null,null,null,null,null,null,null,"June","Quiz 2",4,null,null,"June","Quiz 2",4,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R12)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"June"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S12)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 2"},{"$f":"VLOOKUP(R12,QuizCrossTabAnswer[],MATCH(S12,QuizCrossTabAnswer[#Headers],0))","v":4},null,"Quiz 2",null,"June","Quiz 2",4,null,"June","Quiz 3",2,null,"June","Quiz 2",4]
[null,null,null,null,null,null,null,null,"June","Quiz 3",2,null,null,"June","Quiz 3",2,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R13)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"June"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S13)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 3"},{"$f":"VLOOKUP(R13,QuizCrossTabAnswer[],MATCH(S13,QuizCrossTabAnswer[#Headers],0))","v":2},null,"Quiz 3",null,"June","Quiz 3",2,null,"Sioux","Quiz 1",2,null,"June","Quiz 3",2]
[null,null,null,null,null,null,null,null,"Sioux","Quiz 1",2,null,null,"Sioux","Quiz 1",2,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R14)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"Sioux"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S14)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 1"},{"$f":"VLOOKUP(R14,QuizCrossTabAnswer[],MATCH(S14,QuizCrossTabAnswer[#Headers],0))","v":2},null,"Quiz 1",null,"Sioux","Quiz 1",2,null,"Sioux","Quiz 2",10,null,"Sioux","Quiz 1",2]
[null,null,null,null,null,null,null,null,"Sioux","Quiz 2",10,null,null,"Sioux","Quiz 2",10,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R15)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"Sioux"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S15)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 2"},{"$f":"VLOOKUP(R15,QuizCrossTabAnswer[],MATCH(S15,QuizCrossTabAnswer[#Headers],0))","v":10},null,"Quiz 2",null,"Sioux","Quiz 2",10,null,"Sioux","Quiz 3",9,null,"Sioux","Quiz 2",10]
[null,null,null,null,null,null,null,null,"Sioux","Quiz 3",9,null,null,"Sioux","Quiz 3",9,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R16)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"Sioux"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S16)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 3"},{"$f":"VLOOKUP(R16,QuizCrossTabAnswer[],MATCH(S16,QuizCrossTabAnswer[#Headers],0))","v":9},null,"Quiz 3",null,"Sioux","Quiz 3",9,null,"Timmy","Quiz 1",10,null,"Sioux","Quiz 3",9]
[null,null,null,null,null,null,null,null,"Timmy","Quiz 1",10,null,null,"Timmy","Quiz 1",10,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R17)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"Timmy"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S17)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 1"},{"$f":"VLOOKUP(R17,QuizCrossTabAnswer[],MATCH(S17,QuizCrossTabAnswer[#Headers],0))","v":10},null,"Quiz 1",null,"Timmy","Quiz 1",10,null,"Timmy","Quiz 2",4,null,"Timmy","Quiz 1",10]
[null,null,null,null,null,null,null,null,"Timmy","Quiz 2",4,null,null,"Timmy","Quiz 2",4,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R18)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"Timmy"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S18)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 2"},{"$f":"VLOOKUP(R18,QuizCrossTabAnswer[],MATCH(S18,QuizCrossTabAnswer[#Headers],0))","v":4},null,"Quiz 2",null,"Timmy","Quiz 2",4,null,"Timmy","Quiz 3",8,null,"Timmy","Quiz 2",4]
[null,null,null,null,null,null,null,null,"Timmy","Quiz 3",8,null,null,"Timmy","Quiz 3",8,null,{"$f":"INDEX(QuizCrossTabAnswer[Student/Quiz],ROUNDUP(ROWS(R$5:R19)/COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]),0))","v":"Timmy"},{"$f":"INDEX(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]],MOD(ROWS(S$5:S19)-1,COLUMNS(QuizCrossTabAnswer[[#Headers],[Quiz 1]:[Quiz 3]]))+1)","v":"Quiz 3"},{"$f":"VLOOKUP(R19,QuizCrossTabAnswer[],MATCH(S19,QuizCrossTabAnswer[#Headers],0))","v":8},null,"Quiz 3",null,"Timmy","Quiz 3",8,null,null,null,null,null,"Timmy","Quiz 3",8]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Quiz 4"]
[null,null,null,null,null,10]
[null,null,null,null,null,9]
[null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel Wizard:",null,null,null,"Excel Wizard:",null,null,null,"John Vergara:",null,null,null,null,null,"Weird things that Lester Potts found with a function argumnet array operation is IFNA:"]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFNA(_xlfn.EXPAND(QuizCrossTabAnswer[Student/Quiz],),_xlfn.DROP(QuizCrossTabAnswer[#Headers],,1))","v":"Chantel"},"Chantel","Chantel"]
[null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.LET(_xlpm.z,QuizCrossTabAnswer[#All],_xlpm.sc,_xlfn.DROP(_xlpm.z,1,1),_xlpm.st,IF(_xlfn.SEQUENCE(,COLUMNS(_xlpm.sc)),_xlfn.DROP(_xlfn.TAKE(_xlpm.z,,1),1)),_xlpm.q,IF(_xlfn.SEQUENCE(ROWS(_xlpm.sc)),_xlfn.DROP(_xlfn.TAKE(_xlpm.z,1),,1)),_xlfn.HSTACK(_xlfn.TOCOL(_xlpm.st),_xlfn.TOCOL(_xlpm.q),_xlfn.TOCOL(_xlpm.sc)))","v":"Chantel"},"Quiz 1",9,null,{"$f":"_xlfn.LET(_xlpm.z,QuizCrossTabAnswer[#All],_xlpm.st,_xlfn.DROP(_xlfn.TAKE(_xlpm.z,,1),1),_xlpm.q,_xlfn.DROP(_xlfn.TAKE(_xlpm.z,1),,1),_xlpm.sc,_xlfn.DROP(_xlpm.z,1,1),_xlfn.HSTACK(_xlfn.TOCOL(_xlfn.IFNA(_xlfn.EXPAND(_xlpm.st,,COLUMNS(_xlpm.sc)),_xlpm.st)),_xlfn.TOCOL(_xlfn.IFNA(_xlfn.EXPAND(_xlpm.q,ROWS(_xlpm.sc)),_xlpm.q)),_xlfn.TOCOL(_xlpm.sc)))","v":"Chantel"},"Quiz 1",9,null,{"$f":"_xlfn.LET(_xlpm.s,\"</b><b>\",\n_xlpm.b,_xlfn.TOCOL(\"<a><b>\"&QuizCrossTabAnswer[Student/Quiz]&_xlpm.s&_xlfn.DROP(QuizCrossTabAnswer[#Headers],,1)&_xlpm.s&_xlfn.DROP(QuizCrossTabAnswer[],,1)&\"</b></a>\"),\n_xlfn.FILTERXML(_xlpm.b,\"//b[\"&{1,2,3}&\"]\"))","v":"Chantel"},"Quiz 1",9,null,null,null,"Devonte","Devonte","Devonte"]
[null,"You",10,10,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chantel","Quiz 2",10,null,"Chantel","Quiz 2",10,null,"Chantel","Quiz 2",10,null,null,null,"June","June","June"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chantel","Quiz 3",4,null,"Chantel","Quiz 3",4,null,"Chantel","Quiz 3",4,null,null,null,"Sioux","Sioux","Sioux"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Devonte","Quiz 1",5,null,"Devonte","Quiz 1",5,null,"Devonte","Quiz 1",5,null,null,null,"Timmy","Timmy","Timmy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Devonte","Quiz 2",3,null,"Devonte","Quiz 2",3,null,"Devonte","Quiz 2",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Devonte","Quiz 3",6,null,"Devonte","Quiz 3",6,null,"Devonte","Quiz 3",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June","Quiz 1",5,null,"June","Quiz 1",5,null,"June","Quiz 1",5,null,null,null,{"$f":"_xlfn.IFNA(_xlfn.EXPAND(QuizCrossTabAnswer[Student/Quiz],),{1,1,1})","v":"Chantel"},"Chantel","Chantel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June","Quiz 2",4,null,"June","Quiz 2",4,null,"June","Quiz 2",4,null,null,null,"Devonte","Devonte","Devonte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June","Quiz 3",2,null,"June","Quiz 3",2,null,"June","Quiz 3",2,null,null,null,"June","June","June"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sioux","Quiz 1",2,null,"Sioux","Quiz 1",2,null,"Sioux","Quiz 1",2,null,null,null,"Sioux","Sioux","Sioux"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sioux","Quiz 2",10,null,"Sioux","Quiz 2",10,null,"Sioux","Quiz 2",10,null,null,null,"Timmy","Timmy","Timmy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sioux","Quiz 3",9,null,"Sioux","Quiz 3",9,null,"Sioux","Quiz 3",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Timmy","Quiz 1",10,null,"Timmy","Quiz 1",10,null,"Timmy","Quiz 1",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Timmy","Quiz 2",4,null,"Timmy","Quiz 2",4,null,"Timmy","Quiz 2",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Timmy","Quiz 3",8,null,"Timmy","Quiz 3",8,null,"Timmy","Quiz 3",8]

{"sheet":"Test","index":6,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
[null,"WRAPCOLS and WRAPROWS functions opposite of TOCOL and TOROW"]
[]
[null,"Names","Quiz","Quize Scores",null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(C5:C19))","v":"Quiz 1"},"Quiz 3","Quiz 2",null,"Old School"]
[null,"Sioux","Quiz 1",2,null,{"$f":"_xlfn.UNIQUE(B5:B19)","v":"Sioux"},{"$f":"_xlfn.WRAPCOLS(D5:D19,5)","v":2},4,9,null,{"$f":"INDEX($D$5:$D$19,ROWS(K$5:K5)+((COLUMNS($K5:K5)-1)*5))","v":2},{"$f":"INDEX($D$5:$D$19,ROWS(L$5:L5)+((COLUMNS($K5:L5)-1)*5))","v":4},{"$f":"INDEX($D$5:$D$19,ROWS(M$5:M5)+((COLUMNS($K5:M5)-1)*5))","v":9}]
[null,"June","Quiz 3",2,null,"June",2,5,9,null,{"$f":"INDEX($D$5:$D$19,ROWS(K$5:K6)+((COLUMNS($K6:K6)-1)*5))","v":2},{"$f":"INDEX($D$5:$D$19,ROWS(L$5:L6)+((COLUMNS($K6:L6)-1)*5))","v":5},{"$f":"INDEX($D$5:$D$19,ROWS(M$5:M6)+((COLUMNS($K6:M6)-1)*5))","v":9}]
[null,"Devonte","Quiz 2",3,null,"Devonte",3,5,10,null,{"$f":"INDEX($D$5:$D$19,ROWS(K$5:K7)+((COLUMNS($K7:K7)-1)*5))","v":3},{"$f":"INDEX($D$5:$D$19,ROWS(L$5:L7)+((COLUMNS($K7:L7)-1)*5))","v":5},{"$f":"INDEX($D$5:$D$19,ROWS(M$5:M7)+((COLUMNS($K7:M7)-1)*5))","v":10}]
[null,"June","Quiz 2",4,null,"Timmy",4,6,10,null,{"$f":"INDEX($D$5:$D$19,ROWS(K$5:K8)+((COLUMNS($K8:K8)-1)*5))","v":4},{"$f":"INDEX($D$5:$D$19,ROWS(L$5:L8)+((COLUMNS($K8:L8)-1)*5))","v":6},{"$f":"INDEX($D$5:$D$19,ROWS(M$5:M8)+((COLUMNS($K8:M8)-1)*5))","v":10}]
[null,"Timmy","Quiz 2",4,null,"Chantel",4,8,10,null,{"$f":"INDEX($D$5:$D$19,ROWS(K$5:K9)+((COLUMNS($K9:K9)-1)*5))","v":4},{"$f":"INDEX($D$5:$D$19,ROWS(L$5:L9)+((COLUMNS($K9:L9)-1)*5))","v":8},{"$f":"INDEX($D$5:$D$19,ROWS(M$5:M9)+((COLUMNS($K9:M9)-1)*5))","v":10}]
[null,"Chantel","Quiz 3",4]
[null,"Devonte","Quiz 1",5,null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(_xlfn._xlws.SORT(C5:C19)))","v":"Quiz 1"},"Quiz 2","Quiz 3"]
[null,"June","Quiz 1",5,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(B5:B19))","v":"Chantel"},{"$f":"_xlfn.WRAPCOLS(_xlfn.SORTBY(D5:D19,C5:C19,1,B5:B19,1),COUNTIFS(C5:C19,\"Quiz 1\"))","v":9},10,4,null,{"$f":"_xlfn.SORTBY(D5:D19,C5:C19,1,B5:B19,1)","v":9},{"$f":"_xlfn.CHOOSECOLS(_xlfn._xlws.SORT(B5:D19,{2,1}),3)","v":9},null,null,{"$f":"_xlfn.TOCOL(_xlfn.ANCHORARRAY(G12),,1)","v":9}]
[null,"Devonte","Quiz 3",6,null,"Devonte",5,3,6,null,5,5,null,null,5]
[null,"Timmy","Quiz 3",8,null,"June",5,4,2,null,5,5,null,null,5]
[null,"Chantel","Quiz 1",9,null,"Sioux",2,10,9,null,2,2,null,null,2]
[null,"Sioux","Quiz 3",9,null,"Timmy",10,4,8,null,10,10,null,null,10]
[null,"Timmy","Quiz 1",10,null,null,null,null,null,null,10,10,null,null,10]
[null,"Chantel","Quiz 2",10,null,null,null,null,null,null,3,3,null,null,3]
[null,"Sioux","Quiz 2",10,null,null,null,null,null,null,4,4,null,null,4]
[null,null,null,null,null,null,null,null,null,null,10,10,null,null,10]
[null,null,null,null,null,null,null,null,null,null,4,4,null,null,4]
[null,"Names","Quiz","Quize Scores",null,null,{"$f":"TRANSPOSE(_xlfn.UNIQUE(C23:C37))","v":"Quiz 1"},"Quiz 2","Quiz 3",null,4,4,null,null,4]
[null,"Chantel","Quiz 1",9,null,{"$f":"_xlfn.UNIQUE(B23:B37)","v":"Chantel"},{"$f":"_xlfn.WRAPROWS(D23:D37,3)","v":9},10,4,null,6,6,null,null,6]
[null,"Chantel","Quiz 2",10,null,"Devonte",5,3,6,null,2,2,null,null,2]
[null,"Chantel","Quiz 3",4,null,"June",5,4,2,null,9,9,null,null,9]
[null,"Devonte","Quiz 1",5,null,"Sioux",2,10,9,null,8,8,null,null,8]
[null,"Devonte","Quiz 2",3,null,"Timmy",10,4,8]
[null,"Devonte","Quiz 3",6]
[null,"June","Quiz 1",5]
[null,"June","Quiz 2",4]
[null,"June","Quiz 3",2]
[null,"Sioux","Quiz 1",2]
[null,"Sioux","Quiz 2",10]
[null,"Sioux","Quiz 3",9]
[null,"Timmy","Quiz 1",10]
[null,"Timmy","Quiz 2",4]
[null,"Timmy","Quiz 3",8]