I need some help trying to figure out the best way to handle a task but I am having some difficulty. I have 3 columns of data--A=EntityID, B=Question, C=Answer. What I need to do is create one row of data that has the ID in column E, the questions (there are 5 different questions) as column headers F-J and the answers in each column matched by the entity ID.
I've uploaded a sample sheet that has examples of the before as the after I need. Anything you might do would be greatly appreciated.