For A6

=INDEX(Sheet1!$C$5:$C$59,COLUMN())

and copy across,

etc.

--
__________________________________
HTH

Bob

"Mike" wrote in message
...
I have entered transactions in columns in Sheet1 and need to set up
formulas
in Sheet2 to bring that data into Rows in order to set up a table for
filtering and sorting.
Example: Sheet1 the transactions are entered as folllows:
C5:C59, D5:D59, E5:E59 and so on...

I want those transactions to go into Sheet2, beggining at A6, in rows as
follows:
A6:BC6 would be Sheet1 C5:C59
A7:BC7 would be Sheet1 D5:D59
A8:BC8 would be Sheet1 E5:E59
and so on...

Special formulas???

Your help is appreciated!!!