Transpose Rows to Columns

I'm new here, and have a question that has been stumping me all day! Your help would be greatly appreciated!

I have 19 rows of data spanning 184 columns, and I'm attempting to transpose them to be 19 columns and 184 rows, which would normally be easy. The problem is I need to be able to transpose the numbers while still keeping the formulas on a separate worksheet linking/connecting to the correct cells. I almost need to be able to cut/special paste - transpose, but that's not possible... I don't think.

Any help you can provide would be AMAZING. I hope I explained this correctly, if not please ask any necessary questions. I'm happy to answer!

It Works perfectly..
I'm about to find this solution..
Thank you..

I don't know if that works for what I'm trying to do.

I just need to switch rows to columns but keep the linking to formulas on a separate page still valid. Worksheet 1 is pulling the data from worksheet 2. Worksheet 2 is where I'm trying to switch the rows and columns.

Thanks!!