Bonjour,
essaie ceci
={query(A:E; "select A,B where E = 'condition'" )\
transpose(query(transpose(UNIQUE(query(A:E; "select C,D where E = 'condition'" )));;COLUMNS(UNIQUE(query(A:E; "select C,D where E = 'condition' " )))))}
ou en notation anglo-saxone
={query(A:E, "select A,B where E = 'condition'" ),
transpose(query(transpose(UNIQUE(query(A:E, "select C,D where E = 'condition'" ))),,COLUMNS(UNIQUE(query(A:E, "select C,D where E = 'condition' " )))))}