Hello all, Is there a way to do inner, left, or outer joins in a spreadsheet, e.g. OOo Calc?
For example: sheet 1: a apple b bear c cat sheet 2: a 2 c 1 c 3 inner join sheet 1 and sheet 2: a apple 2 c cat 1 c cat 3 What I usually do is dump the sheet as a tsv file, use the unix join command, and then load it back up. Regards, - Robert --~--~---------~--~----~------------~-------~--~----~ Central West End Linux Users Group (via Google Groups) Main page: http://www.cwelug.org To post: [email protected] To subscribe: [email protected] To unsubscribe: [email protected] More options: http://groups.google.com/group/cwelug -~----------~----~----~----~------~----~------~--~---
