Post date: 10-Apr-2012 09:33:22
Select the data to be transposed in excel
Navigate to cell where you want to paste transpose and Select Paste Special and select Transpose checkbox
Click Ok and you would get required transpose output