Need VBA Loop Code...

[Abdulsalam]

Dears,
I am facing problem to write VBA code in loop for below shown image.
Please note that:
1. The Number of rows is dynamical
2. In one trip vehicle will more than one customer
3. where the trip start until the trip end in row basis but i need to transfer to column basis (from trip start to Trip end)
Could please help to write VBA Code in loop or Array

Thank you,
Abdul Salam.

 

[mole999]

as this appears to be a complete repaste of the question posed yesterday > Need VBA loop code I am locking this thread. You are obliged to read and follow the rules. I am also guessing this may have been posted to other sites in which case you must supply the links so that members do not spend time creating a solution for which you already have an answer