{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Sheet1","index":0,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4],[0,10,0,16]]}
["The data is in this form ",null,null,null,null,null,null,null,null,null,"THE DATA HAS TO BE CONVERTED TO THIS FORM"]
[1,1,"A1","a",{"$f":"COUNTIF($C$2:C2,C2)","v":1},null,null,null,null,null,null,"A1","A2","A3","A4","A5"]
[1,null,"A2","b",{"$f":"COUNTIF($C$2:C3,C3)","v":1},null,null,null,null,null,1,"a","b","c","d","a"]
[1,null,"A3","c",{"$f":"COUNTIF($C$2:C4,C4)","v":1},null,null,null,null,null,2,"d","b","d"]
[1,null,"A4","d",{"$f":"COUNTIF($C$2:C5,C5)","v":1},null,null,null,null,null,3,"c","d",null,"d","a"]
[1,null,"A5","a",{"$f":"COUNTIF($C$2:C6,C6)","v":1},null,null,null,null,null,null,{"$f":"TRANSPOSE(IF($E$2:$E$13=1,$C$2:$C$13,\"\"))","v":"A1"},"A2","A3","A4","A5",""]
[2,2,"A1","d",{"$f":"COUNTIF($C$2:C7,C7)","v":2},null,null,null,null,null,{"$f":"INDEX($B$2:$B$13,SMALL(IF($B$2:$B$13<>\"\",ROW($B$2:$B$13),\"\"),ROW(A1))-1)","v":1},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=L$6)*($A$2:$A$13=$K7),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":"a"},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=M$6)*($A$2:$A$13=$K7),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":"b"},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=N$6)*($A$2:$A$13=$K7),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":"c"},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=O$6)*($A$2:$A$13=$K7),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":"d"},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=P$6)*($A$2:$A$13=$K7),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":"a"}]
[2,null,"A2","b",{"$f":"COUNTIF($C$2:C8,C8)","v":2},null,null,null,null,null,{"$f":"INDEX($B$2:$B$13,SMALL(IF($B$2:$B$13<>\"\",ROW($B$2:$B$13),\"\"),ROW(A2))-1)","v":2},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=L$6)*($A$2:$A$13=$K8),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":"d"},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=M$6)*($A$2:$A$13=$K8),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":"b"},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=N$6)*($A$2:$A$13=$K8),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":"d"},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=O$6)*($A$2:$A$13=$K8),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":""},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=P$6)*($A$2:$A$13=$K8),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":""}]
[2,null,"A3","d",{"$f":"COUNTIF($C$2:C9,C9)","v":2},null,null,null,null,null,{"$f":"INDEX($B$2:$B$13,SMALL(IF($B$2:$B$13<>\"\",ROW($B$2:$B$13),\"\"),ROW(A3))-1)","v":3},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=L$6)*($A$2:$A$13=$K9),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":"c"},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=M$6)*($A$2:$A$13=$K9),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":"d"},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=N$6)*($A$2:$A$13=$K9),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":""},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=O$6)*($A$2:$A$13=$K9),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":"d"},{"$f":"IFERROR(INDEX($D$2:$D$13,SMALL(IF(($C$2:$C$13=P$6)*($A$2:$A$13=$K9),ROW($D$2:$D$13),\"\"),ROW($A1))-1),\"\")","v":"a"}]
[3,3,"A1","c",{"$f":"COUNTIF($C$2:C10,C10)","v":3}]
[3,null,"A2","d",{"$f":"COUNTIF($C$2:C11,C11)","v":3}]
[3,null,"A4","d",{"$f":"COUNTIF($C$2:C12,C12)","v":2}]
[3,null,"A5","a",{"$f":"COUNTIF($C$2:C13,C13)","v":2}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}