Transpose doesn't work with formulas. It moves the formula to new location, but all references to cells/ranges in remain unchanged, and as follows they will be completely wrong. You have to create all formulas from start.
You can select datarange of table (without header row), right-click on leftmost top cell of new datarange OUTSIDE of old datarange (leave an empty row at top of new datarange for new headers), and PasteSpecial.Transpose copied data. After that clear all rows with formulas and enter new column headers. And after that you have to compose new formulas. But there will be a caveat - you get formulas in some cells of table columns, and different ones for every row, and values in other cells in same column. Not a best design IMHO.