I am having trouble figuring out how to transpose data from one sheet to
another. My original data [ 'Sheet1' (2 Columns, n number of rows)] in this
format:

File: file1.dgn
Start: 0
Stop: 1
File: file2.dgn
Start: 2
Stop: 3
File: file3.dgn
Start: 4
Stop: 5
....

And I am trying to transpose it to a second sheet like this
'Sheet2' (3 columns)

File Start Stop
file1.dgn 0 1
file2.dgn 2 3
file3.dgn 4 5
....

Thus, the actual formulas I need on my 'Sheet2' should be similar to this.
=Sheet1!B1 =Sheet1!B2 =Sheet1!B3
=Sheet1!B4 =Sheet1!B5 =Sheet1!B6
=Sheet1!B7 =Sheet1!B8 =Sheet1!B9

(etc.)

I could manually set each column incrementing the cell number, I would like
to do this with a formula. Can someone point me to an example of how I can
accomplish this task using a formula for which I could cut and paste over
the 3 rows and (n) columns?

Tx Much. Tom