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.