how to Transpose the file as mentioned

[punar]

Hi All,

I have attached the actual file, from which i want the target file as attached.

Here the x mark in the actual file will not be in a fixed cell it may vary, from file to file.

The no of rows and columns may also vary from file to file.

The target file should be a new workbook named resultfile.

kindly help me to short out this