transposing row

[Rey]

To all gurus,

1 2 3 4 5
A Gross Rev ReturnsAct Gross Rev ReturnsAct Gross Rev ReturnsAct
B Period 01 Period 01 Period 02 Period 02 Period 03 Period 03
C 2,495,676 2,661,807 8,804,432 3,699,560 13,473,648 6,413,720

I wish to set up the data above to appear as below by using a worksheet function
instead of copying and transposing period by period.

1 2 3
Period 01 Period 02 Period 03
A Gross Rev 2,495,676 8,804,432 13,473,648
B ReturnsAct 2,661,807 3,699,560 6,413,720

Any help will be appreciated. TIA.