Replicating data from a list

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

Cross-posted: http://www.mrexcel.com/forum/showthread.php?t=637654

Hi and welcome to the forum.

Let's say List A, is in Column A and List B, in Columns B-C-D

Then try this.

=B1&C1&D1&A1

Or

=B1&" "&C1&" "&D1&" "&A1

Is this, works for you?

Welcome vgr
Fotis has given you an answer.

I Just wan't to show forum rule#8.

Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

Thanks.

if you are fine with a slightly different layout of output than the one you illustrated above, here is a formulaic approach:

with functions like you can do it like this,of course you show a very simple example