Join Tables

officeandink

Hi

I'm trying join 3 tables together like the following :

-edit : copy and paste didn't work, so here's image of what I mean


Does anyone know a way (hopefully in MS excel) to do this?
It would need to match the rows toghether, by the name.

Thanks if anyone can help

lil_lisa

I don't think MS Excel holds the ability to join tables. If I were you, I would look at storing everything in MS Access, after all it is a database program.

Placebo

how big of a work is it to do manually?
u could sort rows first. then export to csv

then open it in notepad and copy paste it in.

castie

Not a VBA expert but surely it would be possible using that?

aidan_walsh

Not really a web design question so bumping it to the Windows forum.

Fysh

I don't think that Excel will easily let you do that - it's more a database function than a spreadsheet function, tbh.

Edited to add:
I probably should've been clearer in this post - what you're looking to do is only scalable as a database operation, so you'll be better off getting your data into an Access database than trying to kludge a solution together in Excel. See here and here for some information from Microsoft about creating relationships between tables in Access.

JonathanAnon

I'm not sure what you are asking for ... Are you saying that you have a number of tables like the top three tables that you wish to combine into the format of the fourth (bottom) table ? If so, how many rows of records do you have.. ?

woolymammoth

assuming that's just an example of what you mean, what are the actual tables like? how many rows & columns? ideally, your tables (all of them) should have rows for all of the people, whether the column is blank or not. that would make them easier to match up. are you trying to join different worksheets? If it's not a lot of data, then it will be quicker and easier to do it manually i reckon.

Capt'n Midnight

IF the names are unique you could use hlookup and vlookup to populate the bottom table

creating column A with a unique entry for the names might be a little more difficult , but could be done with a script if you want to add new names

or if you have newer versions of excel you could copy and paste the names and use conditional formatting to highlight duplicates and remove them manually

it all depends on what this is to be used for, access licenses aren't cheap so be careful if you head down that path as an entire office will want a copy at the drop of a hat.

openoffice has a database, but nowhere near as polished as Access yet

homer911

Inside join? Outside join? Left join?

What version of Excel? If you have 2010 with Power Pivot this would be easy