Try...

A1, copied down:

=OFFSET($B$1,ROWS($A$1:A1)*3-3,0)

Hope this helps!

In article ,
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