View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default 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.