transposing row

[Rey]

To all gurus,

Gross Rev ReturnsAct Gross Rev ReturnsAct Gross Rev ReturnsAct
Period 01 Period 01 Period 02 Period 02 Period 03 Period 03
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.

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

Any help will be appreciated.

 

[Jason Morin]

See my reply from yesterday. If you'd like the workbook I
tested this with, let me know.

http://tinyurl.com/yruzr

HTH
Jason
Atlanta, GA