Excel numerical task and word entries in a record format as rows and column

Job ID: 31851952

Budget: ₹12,500 – ₹37,500 INR

Column A includes existing members, and column B includes new members that have been referred by members from column A. Column A has many duplicated names. I basically need to find all duplicated entries members in column A and put all the names they referred next to them in column B, C, D, E. I can explain more through live chat.and you need a laptop and a smartphone to complete this task