How to make a pivot table recognize a single cell with multiple answers/info separated by commas, as multiple answers?
I got my first job and I have data from a survey completed by like over 100 people. It's a post-interview survey, so it asks them what company they interviewed for, what roles they interviewed for, what questions they were asked during the interview.
While most people only interviewed for 1 role, there are a few who interviewed for MULTIPLE. So when my supervisor gave me the data in a spreadsheet, some people would have one cell with MULTIPLE roles in just ONE CELL.
I'm trying to count the frequency of each role. But my pivot table recognizes it only by cell. So I have a row with "Junior Analyst, Senior Analyst, Co-op student." But I don't want that. I want each row to have only 1 role.
Also, some people interviewed for the same role but they just spelt it wrong. Like, how do I fix this? HELP ME PLEASE T-T. This is my first project so I don't want to have to ask my supervisor. Thank you reddit gods.
[link] [comments]
Want to read more?
Check out the full article on the original site