Re: [libreoffice-users] Re: Need Calc help

Hello Andreas,

Thank you for your message and your patience.

I am attaching two files - the first one outlines what I am hoping to 
accomplish and the second one has three tables in a worksheet that 
provides a shortened typical entry of the files involved and what I hope 
to see as a result

Hope this provides enough info so that someone can point me in the right 
direction

Thanks again,
Preston

On 8/7/2011 1:12 PM, Andreas Säger wrote:
> Let me retry your request in this way:
>
> 0) Technical prerequisites: Running LibreOffice 3.3.3 under WinXP I
> have a spreadsheet with 2 tables imported from text files which I
> receive on a regular basis from other departments of our organization.
>
> 1) A list of persons with an ID number, name, forname, birthday,
> address info and more:
> 0 Smith Jennifer 1967-07-09 ...
> 1 Smith John 1988-07-29 ...
> 2 Doe Farina 1999-11-12 ...
>
> 2) A membership list with person ID, entry date, department
> 1 2003-12-03 Helsinki
> 2 2007-01-01 Stockholm
> 0 2010-11-11 London
> 2 2009-01-31 Berlin
>
> 3)Now I want to merge both lists so they look like
>
> Smith John 1988-07-29 2003-12-03 Helsinki ...
> Doe Farina 1999-11-12 2007-01-01 Stockholm ...
> Smith Jennifer 1967-07-09 2010-11-11 London ...
> Doe Farina 1999-11-12 2009-01-31 Berlin ...
>
> where the membership's person-ID is merged with the membership
> information.
>
> This entirely technical information about what you have and where you
> want to go could serve as a platform where anybody on this list could
> be involved with some hints, tips, suggestions how to process these
> concrete example data in a spreadsheet, in a database, in a scripting
> language. Example data can be copied into a spreadsheet very easily
> and from there into a database.



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted