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

Expected budget:

Proposed by freelancer

Published: Status: closed

Job description

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

Submitted offers (9)
Polinna 0 deals
  • databases
  • django
  • git
  • ... (+5)
added on 2020-12-10
VDC Solutions 0 deals
  • api
  • dodawanie produktów
  • excel
  • ... (+6)
added on 2020-12-01
ITS 0 deals
  • general applications
  • java
  • linux
  • ... (+4)
added on 2020-11-30
Agata Łacka 4 deals
  • article
  • data analysis
  • databases
  • ... (+2)
added on 2020-11-30
MINT OFFICE 0 deals
  • advertisement
  • bookkeeping
  • data analysis
  • ... (+10)
added on 2020-11-30
Magda Ś. 29 deals
  • data analysis
  • databases
  • dodawanie produktów
  • ... (+1)
added on 2020-11-28
Mariola Kolary 64 deals
  • advertisement
  • article
  • audio recording
  • ... (+28)
added on 2020-11-28
Mikołaj Stegliński 0 deals
  • data analysis
  • databases
  • html5
  • ... (+9)
added on 2020-11-28
Ramon 3 deals
  • data analysis
  • databases
  • dodawanie produktów
  • ... (+8)
added on 2020-11-28