Excel raw data parsing, filtering, and categorizing

I need some help with parsing raw data, filtering, and categorizing. Here is what I need (also attached is the raw data in XLS format).

I don't care if you move the raw data to a DB or whatever you do with it is up to you, whatever is easiest and fastest for you. Please let me know if you'd like to have a call and chat further about the requirements below to ensure there is no confusion.

I'm hoping to have this ready by 10/26, please let me know if this is something you can do and if yes, what your cost would be?


List of unique HP skills listed and number of people (unique count per skill area)

Step 1 - Determine what are all of the 'unique' HP related skills. For example this list will include things like HP-Service Desk, HP Software (Mercury) - LoadRunner, etc. and the list will go on. Do not include things skills like PHP while parsing because although HP is in PHP it is not specific to HP. Also do not include the skill level after the skill. For example in "HP-Service Desk (P2 - Proficient)" I only care for the part that is not in parenthesis, do not include (P2 - Proficient).

Step 2 - Once the full list of unique HP skills have been extracted from the raw data in the excel sheet then I will need a personnel number count for each unique skill. The personnel number count should be a 'unique' count. For example it will look something like this:

[Row 1] HP-Service Desk has X number of unique people who have this skill

[Row 2] HP Software (Mercury) - Load Runner has Y number of unique people who have this skill

[Row 3] ....

[Row 4] ....


Per skill area list the associated unique personnel numbers that map to those skills.

For example:

[Row 1] HP-Service Desk = unique personnel number X, unique personnel number Y, unique personnel number Z

[Row 2] HP Software (Mercury) - Load Runner = unique personnel number X, unique personnel number Y, unique personnel number Z

[Row 3] ....

[Row 4] ....

Skills: Database Administration, Excel, Javascript, Shell Script

See more: excel categorizing, loadrunner raw data, categorizing raw data, m format in excel, level 1 help desk, i need excel help, help desk level 1, categorizing software, up desk, javascript data format, help desk skills, need help with excel, need excel help, runner, Raw Data, mercury, excel service, cost per action, call and, php load data, load excel, excel unique, excel count, move data excel, raw excel data

About the Employer:
( 3 reviews ) San Diego, United States

Project ID: #2572171

Awarded to:


Please check your PM message, thank you.

$50 USD in 2 days
(5 Reviews)

5 freelancers are bidding on average $138 for this job


Quality work assured. Ready to get started. Thanks.

$400 USD in 3 days
(255 Reviews)

Ready for service sir, thanks.

$100 USD in 2 days
(48 Reviews)

Hello, I am ready to complete this project for you. See private message. Regards, Solt

$40 USD in 1 day
(17 Reviews)

P from PN (N = 1,2,3, etc) is personnel number you are talking about?

$100 USD in 0 days
(11 Reviews)