Hi-

Is there any chance someone knows how to combine multiple rows into a single row. Some of the column cells would be duplicate data, in those cases that value would result. In the cases where that does not occur, the new unique value should be displayed in a new column within the same row.

IE:

Orig Data

[A/N] [Type] [Name] [Bene] [Bene Type] [%]
123 IRA Smith Max Primary 100
123 IRA Smith Tom Contingent 50
123 IRA Smith Sue Contingent 50

Reformatted Data

[A/N] [Type] [Name] [Bene] [Bene Type] [%] [Bene] [Bene Type] [%] [Bene] [Bene Type] [%]
123 IRA Smith Max Primary 100 Tom Contingent 50 Sue Contingent 50



Thank you in advance for any help on this!