Consolidate table with array formulas

Hello,

I have a table with identical rows that appear several times with different values. I would like to make a new table consolidating the one I have. I managed to consolidated it by using UNIQUE combined with XLOOKUP, but it does not look like a clean solution.

Is there a procedure to do that with just one formula, using dynamic arrays/lambda solutions?

Explanatory file attached.

Thanks in advance,

F.

TestConsolidateTableEFNov23.xlsx

Thanks, Pivot table is a great solution, I was wondering if there is a way to do that with a formula.
F

Power Query

Please Login or Register  to view this content.