Transpose Data

This would be useful if you wanted to change the orientation of the display of your data, but really didn’t want to retype it all.

Copy all the original data first, find an empty area and click on a cell where you want to begin the copy. Go to Home > Paste > Transpose (you will only see this option if you have copied the data first). Your data will be both pasted and transposed.