Combining two data sets into a master list

[mikaselm]

Hello, all!

I have two lists, that look like this:

2014-10-13_1722.png 2014-10-13_1723.png

Each on a different Sheet. What I want to achieve is something like this, where the contents of one list are just stuck underneath the contents of the second list. I don't care what order they end up in, but I'd like whatever formula I'm using to continue to work even as the original lists are lengthened. I can't mess with the tabs that I'm pulling from, because they're being automatically filled in through a parser from our web surveys. Unfortunately, due to the limitations of the parser, they won't play nicely with one another when piping into the same sheet.

2014-10-13_1727.png

At first, I thought I needed {=(index(Anames!A:B)+INDEX(Bnames!A:B)}, but that wants to add the values together. I also tried {=(index(Anames!A:B)&INDEX(Bnames!A:B)}, but then I get this:

2014-10-13_1732.png

Does anyone have any ideas for how I can merge these two lists?

[FDibbins]

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

(none of those pics came through anyway - at least, not for me)

[mikaselm]

Sorry to take so long to respond!! It's been crazy

This workbook hopefully will help.

example data1.xlsxexample data1.xlsx

thanks, All!!

[FlameRetired]

You might want to consider reposting this one in the VBA section.

In the meantime, a forum administrator, JBeaucaire has a website. One of the examples (VBA) that he provides addresses this same question. Here it is:

https://sites.google.com/a/madrocket...xcelassistant/