hi! I have a difficult data organization problem and I will do my best to explain it so please bear with me. I really hope someone can help me resolve this as i need to do this for work everyday starting tomorrow.

I receive data organized like so:
Column A contains numbers ranging from 2000-30000 in random increments in ascending order.
Column B contains the letters C and P (corresponding to the numbers in column A) in random order.
Column C contains just some random numbers corresponding to columns A and B.

e.g.
Column A Column B-Type Column C
3000 C 5560
5000 C 3560
5400 P 1
5600 P 1
5800 P 1
6000 C 2560
6000 P 2

etc. etc. for many thousands of cells.




How I need the (above) data organized:
Column A Column B-Type C Column C-Type P
3000 5560 N/A
5000 3560 N/A
5400 N/A 1
5600 N/A 1
5800 N/A 1
6000 2560 2
etc. etc. for thousands of cells.

I hope this makes sense.

I know how to use the "sort" function in excel but it doesn't do this kind of sorting i dont think.

if someone can please help me i would greatly appreciate this!!! please ask me questions if something does not make sense. thank you!!