Changing Column Data into Row Data

[bapswarrior]

Hey Genius Community

I have a ton of data (attached a sample) that is driven by formula. The way I have the data set up is I would have A,B,C,D..... in column A and on the top row I have YTD, 1 year, 3 year and 5 year..... and so on column headers. I want to be able to pivot and slice data and therefore want data to be in the following format (example file: "Desired Output) A,B,C,D in col A and YTD, 1year, 3 year and 5 year in col B and each associated value to be in each row corresponding accordingly. I want this in such that when original data changes so should that output. I have tried using the pivot trick and double clicking on grand total and then pivoting off that but it doesn't work.

Please help. TIA