Data Cleaning in Excel for Leadership Survey

Post By admin

Project Title: Data Cleaning in Excel for Leadership Survey

Project Description:
I have a data file in which team members evaluate each other in terms of leadership. Items need to be manually sorted in excel before we can use it for our statistical analysis.

Regarding the Excel sheet:
– Each row includes survey responses from a single person over three days

– There are columns that mention the persons’ names and teams

– In the current (survey) format, a set of columns describes how the team members evaluated each other’s’ leadership values. The first column of the set is the rating they gave themselves.

– The second column is the name of the first team member they rated in the original survey form.

– The third column contains the rating the person gave the first member they rated in the survey. From here, it continues with all the remaining team members.

– Rather than the structure “1) own rating 2) first other name 3) first other rating 4) second other name 5) second other rating….” we need the values a person received in their own row. For this, we need new columns in the excel sheet with this information: 1) own rating 2) first rating another team member gave this person 3) “second rating another team member gave this person…”

– Moreover, there are some problems in the data that I would like you to highlight. For example, if there are two rows for the same name of a team member, highlight them. Similarly, some team members evaluate people who we don’t have in our data sheet. Please highlight their names and ratings, too.

There are around 100 teams and 546 team members who evaluated each other over 3 days.

For similar work requirements feel free to email us on

  • Facebook
  • Twitter
  • Google Plus
  • Linkedin
  • 6 years ago Patrick Bleakley

    Can you please help me to enrich the database of my company employees in our CRM?


Add a comment