VBA Code to transpose data from Sheet 1 to Sheet 2 in a specific order

Thank you MickG! Works beautifully! Just what I was looking for!

You're welcome
NB:- "Kalak's" code is a much better effort !!!!!

Thanks Mick.

I tried them both and both seem fine to me.

Only if there's a large dataset ...