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:

Please Login or Register  to view this content.

Please try in K1: and copy down:

Formula:

Please Login or Register  to view this content.