Moving column entries to row entries (and vice versa) automatically instead of manually?

I'd like to move all current column entries to row entries and row entries to column entries (I currently have my quarter and monthly dates in column 1 and would like those instead to be column titles in row 1). Mistake I'd like to fix automatically if possible instead of manually moving each cell's entries. Can't imagine this is possible, and would lose all formulas, but am hoping it might be. Thank you.

does this help?

http://chandoo.org/wp/2013/02/01/tra...excel-formula/