Need help to create macro, which will combine each cell in col A with all non empty cells in col B. All the inputs are variable

Need help to create macro, which will combine each cell in col A with all
non empty cells in col B. All the inputs are variable

first input Col A: (variable rows/data) 100114 100119 100935
second input(variable rows/data) Col B: 0001FVT1444 0001TBL3885
0001PCU3885 0001TPE3885 0001HNG3885 0001FVT14R4
output Col C: 1001140001FVT1444 1001140001TBL3885 1001140001PCU3885
1001140001TPE3885 1001140001HNG3885 1001140001FVT14R4 1001190001FVT1444
1001190001TBL3885 1001190001PCU3885 1001190001TPE3885 1001190001HNG3885
1001190001FVT14R4 1009350001FVT1444 1009350001TBL3885 1009350001PCU3885
1009350001TPE3885 1009350001HNG3885 1009350001FVT14R4
Thanks