Hi Cardslinger,

If you just want to get the data from a column in sheet1 to a row in sheet2
you can:

1. Select the B1:B24 range and click Copy. Select A2 on sheet2 and choose
Edit, Paste Special, and check Transpose.

2. If you need to build a formula then: on sheet2 select the range A2:W2
and enter the formula =TRANSPOSE(Sheet1!B1:B24), but don't press Enter.
Instead press Shift Ctrl Enter.

3. You can also use the OFFSET function without the need to do an array
entry as follows: =OFFSET(Sheet1!$B$1,COLUMN(A1)-1,0)
--
Cheers,
Shane Devenshire


"Cardslinger" wrote:

Information on sheet 1 is in columns with 24 rows, i.e. B1:B24, B26:B50 and
so on. Sheet 2 is in rows of 24 columns with names corresponding to the
columns on sheet 1 i.e. A2:W2 Then B2:X2. I can get the data if I manually
select each cell on sheet 2 & =Sheet1!B2 & so on.
Is there a formula to accomplish this as each set of imported data to the
rows on sheet 2 are 24 row numbers apart. (sheet 2 b4 = sheet 1 c50 & sheet 2
b5 = sheet 1 b74).
Thanks