Non VBA method

in an adjacent column or any free column (lets say N in this example)
type in
N1 = 3
N2 = 16
N3 = 29
highlight and fill down to 1002, it should map your pattern

then in cell M2 type in ="=Sheet2!B"&N1 and fill down to 1002 again

highlight column M - Copy and paste values
while M is still highlighted run text to column and click finish

this sounds like many steps but its not really