Transpose Vertical Data to Horizontal

Hi
I have the attached worksheet that I would like to know how to move the data from Vertical to Horizontal

Is there a set function to do this or does it require a macro?

Thank you

select the range 49 columns, 49 rows (A1:AW49) then copy, click somewhere under the 49th row and go to paste special, transpose, then you can delete the original data if you desire

I could do you a code if you wish, but not sure your desired result. Please include your desired result with the attached above.

Thank you!!
I wish I could get back all of the time I have wasted by not knowing how to do that...

Much Appreciated

The code produces the result on new sheet. If your result different, you need to attach your desired result

Thanks AB33

Scott's instruction worked - Now I can fish....