Linking a repeating pattern of non-adjacent cells
 

I need to transpose an Excel worksheet where every fourth cell is selected
and placed into a single column of another workbook. Can I write a formula
to do this so I don't have to manually copy each cell I need?

If your original data were in col. A, you could put this
in A1 of a new wb:

=OFFSET([Book8]Sheet1!$A$1,ROW()*4-4,)

and drag down. It'll pull in the values in row 1, row 5,
row 9, and so on.

HTH
Jason
Atlanta, GA

-----Original Message-----
I need to transpose an Excel worksheet where every
fourth cell is selected
and placed into a single column of another workbook.
Can I write a formula
to do this so I don't have to manually copy each cell I
need?
.

Hi
try somethin like
=OFFSET($A$1,(ROW(1:1)-1)*4,0)

--
Regards
Frank Kabel
Frankfurt, Germany

wdg006 wrote:
I need to transpose an Excel worksheet where every fourth cell is
selected and placed into a single column of another workbook. Can I
write a formula to do this so I don't have to manually copy each cell
I need?