Combine 2 spreadsheets by parsing from one to the other

S

Steve

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with multi-level list 0
2 spreadsheets - populating one by multiplys of another 3
VBA Programming 1
Formula help, please. 3
excel if condition or vba 3
Modify working code to expand the output. 5
List all tables, including document structure 0
modified pivot table using a macro 2

Top