Excel: How to transpose data?

Dear Excel Experts,

In Excel, I can click “Paste special” and “Transpose”
if I want to transpose column data to row data.

But how do I transpose the large volume of data at once as following table?


Original Table:

Project 1
A 47659
B 63745
C 65240

Project 2
A 71062
B 60252
C 47857
........................................

Project 100
A 8609
B 26054
C 19808




Transposed Table:
A B C

Project 1 ? ? ?

Project 2 ? ? ?
.................................................................................
Project 100 ? ? ?


Thank you so much for your help!