Thanks. That works great!

"bpeltzer" wrote:

If you're trying to copy every third row from B to A, enter the formula
=OFFSET($B$1,ROW()*3-3,0) in A1, and autofill down through the appropriate
cells in column A.

"Xianbo" wrote:

Hi,

I am trying to copy contents from, say, B1, B4, B7, .... into A1, A2,
A3,.... And did not know how to set up a formula to do that. I'd appreicate
for any suggestions.

Thanks,
Xianbo