I have two colums. Both include 8 digits numbers with shorter numbers between. I want to calculate how many rows between two 8 digits numbers have first one and the second one and then I need to add second column next to the first one but with adding missing rows (difference beetwen first one and second one). For example - fist column has 9 rows and second one has 12, so I need to paste second column next to the first with adding 3 extra rows below last row in first column.

Reverend Jim 2,514

Reverend Jim 2,514

Reverend Jim 2,514

Reverend Jim 2,514

TnTinMN 418

Reverend Jim 2,514

tinstaafl 1,075

TnTinMN 418

Reverend Jim
commented:
Likewise +12

Tarwit
commented:
excellent! well done! +0

Reverend Jim 2,514

TnTinMN 418