Libre Office calc functions - sheet consolidation - duplicates - comparing the contents of two lists

This job is closed

Settle at least one deal via useme to enable the posting of multiple versions of offers (e.g. cheaper and more expensive).

Details

Hello,

the order is for a Libre Office calc expert, which consists of several functions.

1. There are several hundred sheets with data in 6 columns in the calc file: name + surname, street + number, code + city, phone number, e-mail address, www.

All sheets must be consolidated into one sheet.

2. Duplicates should be removed from this sheet, bearing in mind that duplicates must be searched and removed by e-mail addresses, ie surnames, first names, street names, zip codes and cities are not taken into account and can be multiple.

2. In one column there are names and surnames - in the given order - which should be divided into 2 columns> given names >> surnames

3. From the first names column you should sort the data - whole lines - that belong to female names, the rest will be male names. There are no impersonal lines.

The challenge is that the names are foreign German, French, Italian and English.

If necessary, I can send lists of male and female names from any language.

I am asking for serious offers from professionals who know how to perform these functions.

It is possible that I will have other similar assignments.

best regards

Thomas

The job in figures:

Excel Libre Office functions calc sheet consolidation, duplicates, compare the contents of two lists

Offers (10)

Polinna
registered:
posted:
Offer visible to Employer
Rafał Skowroński
registered:
posted:
Offer visible to Employer
VDC Solutions
registered:
posted:
Offer visible to Employer
ITS
registered:
posted:
Offer visible to Employer
Agata Łacka
registered:
posted:
Offer visible to Employer
MINT OFFICE
registered:
posted:
Offer visible to Employer
Magda Ś.
registered:
posted:
Offer visible to Employer
Mariola Kolary
registered:
posted:
Offer visible to Employer
Mikołaj Stegliński
registered:
posted:
Offer visible to Employer
Ramon
registered:
posted:
Offer visible to Employer