is it possible to merge rows based on certain criteria ?

i want to merge rows if they have the same day and task

pic 1 .png

pic 2 .png

with Power Query use group rows and sum duration.
that'all what can I say with the pisture

thanks ❤️❤️❤️ i see power query everywhere it's time to learn it

Originally Posted by ahmed amamr

thanks ❤️❤️❤️ i see power query everywhere it's time to learn it

I'm sure it's time to do it

Power Query

It is also possible with 2 formulas:

Please try in G1:

Formula:

=UNIQUE(A1:D3)

Please try in K1: and copy down:

Formula:

=SUMIFS($E$1:$E$3,$A$1:$A$3,G1,$B$1:$B$3,H1,$C$1:$C$3,I1,$D$1:$D$3,J1)