How do I combine 2 arrays?

Hello,

I've been struggling to combine 2 arrays into one without messing up all of the data.

Both arrays have 2 columns. First column contains IDs and the second one contains prices. I need a third array with all of the IDs (some are the same in array 1 and 2) and prices from both arrays, each in its own column - so array 3 has 3 columns.

I've been trying with For each loops in different ways but I always end up with either just 1 value (the loop doesn't run correctly) or I'm just overwriting array 1 with array 2 instead of combining them.

Any help would be much appreciated!

Thank you for you capx but I can't access it; I tried from different computers (on different networks) and I always get Error (400); something went wrong

Try again. Dropbox changed the format of its links which seem to break on this site.

I'm sorry for such a late reply but I was so happy with your solution I got utterly distracted.

Thank you, you are a life saver :)

Now, all I have to do is set up something like excel’s vlookup function and life will be sunshine and daisies again :)