How do i align multiple columns in excel by name and sales?

Please ref attached image.

I need to align sales for the agents in single row to match their names. The problem is that in Jan the number 1 agent may be on 5th spot and in 12th place in the third month. I need to bring the agent and his corresponding sales in one row.

Recent Questions...