Hi,
I have 2 lists:
[Note: Treat the commas as separate columns]
LIST A:
loc1
lo-2
loo3
loi4
LIST B:
1,abba,75
2,babba,356
3,bom,22
Final Product Required:
1,abba,75,loc1
2,babba,356,loc1
3,bom,22,loc1
1,abba,75,lo-2
2,babba,356,lo-2
3,bom,22,lo-2
.
..
...
..
3,bom,22,loi4
So basically it's repeating all of list B for each value in List A. It would be great if you could tell me a way to do this w/o using VBA..
I have 2 lists:
[Note: Treat the commas as separate columns]
LIST A:
loc1
lo-2
loo3
loi4
LIST B:
1,abba,75
2,babba,356
3,bom,22
Final Product Required:
1,abba,75,loc1
2,babba,356,loc1
3,bom,22,loc1
1,abba,75,lo-2
2,babba,356,lo-2
3,bom,22,lo-2
.
..
...
..
3,bom,22,loi4
So basically it's repeating all of list B for each value in List A. It would be great if you could tell me a way to do this w/o using VBA..