I have two columns A and B. Each row of Column A has text type data
and each row of Column B has integer number or empty cell.

Each of them related.

The idea to do is that how to join each row from column A with empty cells
from column B.

Of course in a different sheet.

Thanks

Francisco