Here's a little tip that will eliminate the need to retype data. For example, say you enter data into a spreadsheet with 4 column headings across a row and 4 row headings down a column as follows:

Your data will now be transposed