It's soo hard hey.

I just cycle through all our distraction techniques (songs, toys, random objects within arms reach ) until something works, other times I just have to tell him where we are going/ what we are doing next.

Sometimes though it's just a wait it out, protect him from harming himself but latting him go nuts for a min and trying again. Sometimes they just need to get that frustration out.

Something else I do is give him a choice - ie you can hold my hand or I can carry you. Sit in the trolley or walk nicely. You can wear your red shirt or your blue shirt. It gives them the feeling of having some control while you get the outcome you need/ want.

Not sure if any of that helps (and sorry if I've repeated anyone, haven't read the other responses)