Two different tables - 4 columns each

[NElmer]

How can I merge two different tables that each have 4 columns one of the columns in each table contain a policy number. The other 3 columns have values in them, as well as some blank cells.

I need to merge/combine the two tables so that when sorted by policy number (lowest to highest) the other 3 columns will fall into place as they should either showing the correlating value or blank cell related to that policy number.

Example: merge A:D with G:J to produce new table starting at M:P with data from B:D and H:J into N:P respectively.

Thank you!

 

[Fluff]

How about

=sort(vstack(a2:d8,g2:j7))

 

[NElmer]

Hello, thank you for quick reply. That produces a #NUM! error. However, I didn't format the data as tables yet- would that make any difference?

 

[Fluff]

Nope, that won't matter.
Is the error in some cells?

 

[NElmer]

I may have figured it out! I think it was the lack of tables that was causing the issue. However, it is not intertwining the values it is just now 1 table on top of the other

 

[NElmer]

Just saw you reply about error on cells. Some do have that little triangle is the corner bc I have it a general format. I will mark to ignore those and see if that helps

 

[Fluff]

Can you post some sample data
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[NElmer]

One more question. (Forgot to add this part in my inital post and example) the second table will have some duplicate policy numbers that are also in the other column. If there a version of this formula that can tell it to ignore the duplicate policy numbers on the second table?

 

[Fluff]

Please see post#7