split text from duplicates into seperate new columns unique text value


i would like to take duplicate values from a unique cell value and bring it to to another column on the same row of the duplicate row creating a new column. for example if you have two duplicates from cell a1 through cell d1 and again in a2 through d2 but cells e1 and e2 have two different values and there could be more then 2 duplicates there could be 4 or 5 i want to bring all unique values from e2 to the next column in e1 etc if there were unique values in e3 e4 e5 they would all end up in the same row as row 1 ? thank you for your help.



Please attach a workbook to both demonstrate the original data and the expected result.
Variatus (rep: 2803) Sep 13, '18 at 8:02 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login