convert rows to columns?

I'm working with a spreadsheet where cells A2-A12 contain the categories for a data set and then each column from B-AP has the appropriate value for those rows. The way I want it to look is to have cells A2-K2 contain the categories and then rows 3-45 contain the data. So basically, turn the rows into columns. Is there a way I can do that?

Nevermind, that was easier than I thought. Paste Special>Transpose (if anyone ever searches for this in the future...)