I have some data a little bit mixed up. : -)
<-> Knowledge in corporation / profession fields is needed besides Excel knowledge.
I have an excel list with 1800 professions (IT, financial, etc.)
--> Please check the attachment! : -)
Most of them are sorted by (many) categories and many professions are duplicated.
I would like to have a list of professions sorted by categories and have maximum 14 categories. Besides each category the list of profession should be in A-Z order.
Some business / corporation knowledge is needed in order to be able to group the 20-30 categories (and the professions) and integrate them (with the professions) so that at the end there will be a list of 14 main categories – please see underneath - (profession fields) and the professions are relevant to those categories.
14 Main categories needed for the new list:
FINANCE & ACCOUNTING
SUPPLY CHAIN - PROCUREMENT
As duplicated professions should be removed, it is possible that at the end there will be a list of around 1700-1800 professions sorted under the main categories.
row 63 --> should be a profession under data management and not administrator
Manufacturing category should be part of one of the main new categories needed
(you might need to do some internet research in order to set some of the categories under the proper categories, as the list comes from many places, and I would need a relevant complete profession list). :- )
I would need it to be done within 24 hours.
Waiting for your kind proposals.