Merge first columns of a table, keeping structure of additional columns

I apologize as this information is probably available on the forum somewhere, but I wasn't even sure what terminology to use.

I need to combine the first column of several tables, where some information is unique, and some is repeated. However, I need to keep the structure of additional the columns, or at least the adjacent ones, in the new table.

The image below hopefully explains it better.

Excel_Columns.png

This has come up a few times and I'm completely stumped how to do this kind of merge.

If you can get your source data into three columns, e.g. Table#, Month, Value, you could then create a Pivot Table in seconds to show you the data as shown.

2019-03-01_14-37-47.jpg

2019-03-01_14-39-54.jpg

I can reproduce your required results but I'm not sure this is quite what you are looking for.

All I have here is 3 simple vlookup formulas, one per table. For example referencing the attached workbook in E6 and copied down:
=IFERROR(VLOOKUP(D6, $A$2:$B$4, 2, FALSE), "")

The formulas in F6 and G6 are similar.

The attached workbook implements the above.

Anywhere close?

This is my first time using this forum and I want to say a huge thank you to this community. I did not expect responses so quickly!

Thanks to the first poster for your solution. It worked great for my posted example, but the actual workbook has thousands of entries scattered across about a dozen worksheets.

GeoffW283, your formula was perfect for what I needed.

What I ended up doing was combining the first columns of every worksheet using the VBA script I found at extendoffice.com

I'd post a link but I do not have permission yet.


From there I was able to create a primary column of only unique entries using the remove duplicates feature.

Once I had this, GeoffW283's formula did exactly what I needed- once I looked up how vlookup worked!

Thanks again to both posters for responding. You've been a huge help!

Glad we could help. Thanks as well for the feedback and reputation points