Multiple dates in Multiple rows and columns with repeating IDs

Hi All,

I am having multiple dates in my table but they are on separate rows see below table.

I want to calculate how many percent orders are in order date  to approved stage, approved stage to ship stage and ship stage-delivered stage. also want to calculate the days difference between each stage. is there any way i can bring it in a single row? or any calculation which can be applied to get the output like below:-

Nos. in the screenshot are just for demo, TIA