Excel task and sales data

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 members in column A and put all the names they referred next to them in column B, C, D, E. and make one folder consisting of all data