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.

Tarwit 0 Newbie Poster

Reverend Jim 4,899 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Hazuan Nazri 0 Junior Poster in Training

Tarwit 0 Newbie Poster

Reverend Jim 4,899 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Tarwit 0 Newbie Poster

Tarwit 0 Newbie Poster

Tarwit 0 Newbie Poster

Reverend Jim 4,899 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Tarwit 0 Newbie Poster

Reverend Jim 4,899 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

TnTinMN 418 Practically a Master Poster

Tarwit 0 Newbie Poster

Reverend Jim 4,899 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

tinstaafl 1,176 Posting Maven

TnTinMN 418 Practically a Master Poster

Tarwit commented: excellent! well done! +0

Reverend Jim commented: Likewise +12

Reverend Jim 4,899 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster

Tarwit 0 Newbie Poster

Tarwit 0 Newbie Poster

TnTinMN 418 Practically a Master Poster

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.