I have a computer generated list of skills for 60 candidates.
The goal is to build a table that tallys the skills across all candidates to determine which skills are most frequest there most important.
However the list of skills I have for each candidate is messy. For example, Candidate A might have AWS, whilst Candidate B might have AWS certification.
Ultimately, I just want to tally this as AWS = 2 instead of having two separate skills.
Is there a way for me to compare the skills column for candidate B with candidate A to determine which cells are similar so that I can mark these as 2 of the same skills.
I would like to please stress, that I am trying to find where they are similar not exact because I dont want to miss skills that are technically the same but written slightly different.
I would eventually like to repeat this process for 60 candidates in today to produce a table that tallys skills accross all candidates and avoids duplications under slightly different names.
In the attached image, you can see that AWS for candidates A & B are in different rows.
Thank you!
The goal is to build a table that tallys the skills across all candidates to determine which skills are most frequest there most important.
However the list of skills I have for each candidate is messy. For example, Candidate A might have AWS, whilst Candidate B might have AWS certification.
Ultimately, I just want to tally this as AWS = 2 instead of having two separate skills.
Is there a way for me to compare the skills column for candidate B with candidate A to determine which cells are similar so that I can mark these as 2 of the same skills.
I would like to please stress, that I am trying to find where they are similar not exact because I dont want to miss skills that are technically the same but written slightly different.
I would eventually like to repeat this process for 60 candidates in today to produce a table that tallys skills accross all candidates and avoids duplications under slightly different names.
In the attached image, you can see that AWS for candidates A & B are in different rows.
Thank you!
