Posts tagged Transpose

Excel 2003/2007/2010/2013: Copying a row and pasting in column and vice versa

When working with huge amount of data in Excel, there will always come a time that you want to copy the contents of a row and paste it in a column, or vice versa. Have you had such encounter before? Suppose your summary report lists years downwards, or in a column. But then your boss requires the years are listed across, that is, in a row. If there are just few years in the report, it will be just easy to re-type them manually. However, if the report has years… Read More