Help Transpose Data

Hi Siva

Thanks for your reply. I understand that the previous sheet didn't have a delimiter before the city to help with the tranpose.

Could you kindly look at the following spreadsheet and advise if it could be done with this one?

Many thanks