I just need someone to get me kicked off on my next project.

I have an input sheet with 25 column headers. The 1st one gives the person's name, the second says what team you were on, and the rest are answers to a survey. The survey tells you to rank yourself, and then rank the different members of your team(The names can be in any order).


So an input could look like this:

Dave Brown Team A 1 2 3 4 5 Molly Jones 3 4 2 1 4 Tom Snyder 3 4 5 2 2 5

I have an output sheet that needs to list the rankings you gave yourself, and what everyone else in your team gave you.

Can someone point me in the right direction?

Thanks!