So here is an example,

I want select the cells adjacent to empty cells (e.g Numbers which are in bold) and move them up to the third column on the side of the same number.

I have data in following format:

A1 B2  2 C3 D4  4 E5 F6  6 G7  7 H8 

I want the output in following format:

A1 B22   C3 D44   E5 F66   G77   H8 

Can anyone help since the data I have is much bigger near to 500 rows.

Thank you!

​So here is an example,I want select the cells adjacent to empty cells (e.g Numbers which are in bold) and move them up to the third column on the side of the same number. I have data in following format: A1 B2  2 C3 D4  4 E5 F6  6 G7  7 H8  I want the output in following format: A1 B22   C3 D44   E5 F66   G77   H8  Can anyone help since the data I have is much bigger near to 500 rows.Thank you!  Read More

​