{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DONNEES","CONC"],"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":"DONNEES","index":0,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Client",null,null,null,null,null,null,null,null,null,null,null,"E-mail",null,null,null,"A prendre"]
[43,null,null,null,null,null,null,null,null,null,null,null,"oiseau@orange.fr",null,null,null,1]
[43,null,null,null,null,null,null,null,null,null,null,null,"chien@orange.fr",null,null,null,0]
[57,null,null,null,null,null,null,null,null,null,null,null,"rat@orange.fr",null,null,null,1]
[111,null,null,null,null,null,null,null,null,null,null,null,"loup@orange.fr;brebis@orange.fr",null,null,null,1]
[111,null,null,null,null,null,null,null,null,null,null,null,"moineau@orange.fr",null,null,null,1]
[111,null,null,null,null,null,null,null,null,null,null,null,"brebis@orange.fr",null,null,null,1]
[99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[14,null,null,null,null,null,null,null,null,null,null,null,"elephant@orange.fr",null,null,null,0]
[]
[null,"Objectif : concaténer en feuille \"CONC\", colonne D,  tous les mails du client de CONC!Bx si la colonne Q contient \"1\""]
[null,"Elimination des doublons dans les mails"]
[]
[null,"Dans le fichier original : 450000 lignes de données ! (30 Mo) !"]
[]
[null,"Merci par avance pour l'aide apportée."]

{"sheet":"CONC","index":1,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Code",null,"Mails concaténés","Résultat attendu en D :"]
[null,43,null,null,"oiseau@orange.fr","oiseau seulement car il y a un 0 dans Q3"]
[null,111,null,null,"loup@orange.fr;brebis@orange.fr;moineau@orange.fr","4 mails pour le 111, mais 1 en doublon, donc 3 au final."]
[null,99,null,null,"Rien car absence de mail"]