ExcelBanter - Combine 2 spreadsheets by parsing from one to the other

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Combine 2 spreadsheets by parsing from one to the other (https://www.excelbanter.com/excel-programming/442543-combine-2-spreadsheets-parsing-one-other.html)

Steve

Combine 2 spreadsheets by parsing from one to the other

I have one spreadsheet -a as follows:
one column...
A
B
C
D
I have another spreadsheet as follows:
one column...
1
2
3
4
I want TO CREATE FROM THEM INTO ONE SPREADSHEET:
A 1
A 2
A 3
A 4
B 1
B 2
B 3
B 4
C 1
C 2
C 3
C 4
D 1
D 2
D 3
D 4
Thanks for any directions.

All times are GMT +1. The time now is 05:48 AM.