Linking a repeating pattern of non-adjacent cells

W

wdg006

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?
 
J

Jason Morin

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
 
Top