How can I match two columns of data by name?

Question

I have two sets of data that look something like this:

Bill  | 7
Sam   | 13
Chuck | 9

and

Bill  | 6
Sam   | 3
Beth  | 6

and I want:

Beth | 0  | 6
Bill | 7  | 6
Chuck| 9  | 0
Sam  | 13 | 3

I don't even care if the data ends up looking like this:

Bill | 7  | Bill | 6
     |    | Beth | 6
Sam  | 13 | Sam  | 3
Chuck| 9  | Chuck| 0

I just would like to match up the names.

Answer 1

Your desired outcome - I've never seen such an order in "real life practice".

To use the data, I would go with an operating system tool to combine the source files
(like: copy file1 + file2 newfile.csv; new file extension for easily recognizing by OOo Calc).

In CALC you can then sort / filter, to show a persons data together, or sum / calculate with it.

If you want standard operations, like SUM per person, check out the pivot table feature.

HTH