Excel- How to identify if number repeats and copy value into in a different column to another column

Hi There, I have an spreadsheet with many many rows and I would like to identify if the numbers in A column repeat and grab the values in C column and put it in different columns but same row. Please see image explaining better -(I hope)

I have search the web for formulas but I  haven't found any that suits this problem.

I manage to filter the unique R Numbers using the filter function:

But still I can't filter the C column and put it in K,M,O columns.

Thank you in Advance