{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"macros":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":44,"n_cols":7,"rows_kept":44}
["de 1 à 850 fichiers source (mesure 1 à mesure n), de matrices identiques ~64 colonnes et ~30 lignes"]
[]
["mesure 1",5,4,3,2,1]
[null,5,4,3,2,1,"A"]
[null,50,40,30,20,10,"B"]
[null,500,400,300,200,100,"C"]
[null,6.6,5.5,4.5,3.5,2.5,"D"]
[]
["mesure 2",5,4,3,2,1]
[null,2,74,5.23,8,1,"A"]
[null,50,40,30,20,0.05,"B"]
[null,410,400,258,180,15,"C"]
[null,2.4,2.5,2.3,2.2,2.1,"D"]
[]
[]
["mesure 3",5,4,3,2,1]
[null,6,8.5,7,5,4,"A"]
[null,57,48,39,21,0.5,"B"]
[null,52,5.6,84,75,11,"C"]
[null,7.8,5.9,7.1,8.1,5.2,"D"]
[]
["Résultats attendu"]
["Empiler les colonnes sur une seule"]
[null,{"$f":"A3","v":"mesure 1"},{"$f":"A9","v":"mesure 2"},{"$f":"A16","v":"mesure 3"}]
["A1",{"$f":"F4","v":1},{"$f":"F10","v":1},{"$f":"F17","v":4}]
["B1",{"$f":"F5","v":10},{"$f":"F11","v":0.05},{"$f":"F18","v":0.5}]
["C1",{"$f":"F6","v":100},15,11]
["D1",{"$f":"F7","v":2.5},2.1,5.2]
["A2",{"$f":"E4","v":2},{"$f":"E10","v":8},{"$f":"E17","v":5}]
["B2",{"$f":"E5","v":20},{"$f":"E11","v":20},{"$f":"E18","v":21}]
["C2",{"$f":"E6","v":200},180,75]
["D2",{"$f":"E7","v":3.5},2.2,8.1]
["A3",{"$f":"D4","v":3},{"$f":"D10","v":5.23},{"$f":"D17","v":7}]
["B3",{"$f":"D5","v":30},{"$f":"D11","v":30},{"$f":"D18","v":39}]
["C3",{"$f":"D6","v":300},258,84]
["D3",{"$f":"D7","v":4.5},2.3,7.1]
["A4",{"$f":"C4","v":4},{"$f":"C10","v":74},{"$f":"C17","v":8.5}]
["B4",{"$f":"C5","v":40},{"$f":"C11","v":40},{"$f":"C18","v":48}]
["C4",{"$f":"C6","v":400},400,5.6]
["D4",{"$f":"C7","v":5.5},2.5,5.9]
["A5",{"$f":"B4","v":5},{"$f":"B10","v":2},{"$f":"B17","v":6}]
["B5",{"$f":"B5","v":50},{"$f":"B11","v":50},{"$f":"B18","v":57}]
["C5",500,410,52]
["D5",6.6,2.4,7.8]