Combine (Concatenate) values from two rows for all fileds

Question

Hi all,

How can I concatenate values from two rows, for all fields in the table, if their value for FieldName is equal?

e.g Input:

FieldName1234567Ia bc d I e    fII   DE  IIABC   F

Output:

FieldName1234567Iaebc dfIIABCDE F

IMSL · Accepted Answer

I had to use summarize tool! :D

DataNath · Accepted Answer

@IMSL if you need this to be dynamic i.e. there could be more fields in future then something like this ought to handle it without further manual intervention: