Live-updating Transposed Sheet

I have a vertically-formatted template that I enter data into, due to the importing requirements of another piece of software. But, I prefer the data printed out horizontally for my own use. I'd like to create another sheet in the template that transposed the data horizontally (columns -> rows). I've tried the Copy>Paste Special>Transpose function but some of the formulas do not work. I've tried pasting the Values, still doesn't work.

Is there a way to have this live-update the data from sheet 1 into transposed form in sheet 2?