Transposing data in excel document

Hi..
I am working with large excel document.Mainly cut/paste from one document to another document. I woulg like to transpose columns into rows.

please the details ( example of input data) and desired result.

P.s; The lay out will be the same , but fields can more than the example

Thanks
Jimmy

Jimmy, this is the second questiion with Word examples. It would be much better to attach a zipped workbook.