Combine (Concatenate) values from two rows for all fileds

[IMSL]

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:

FieldName	1	2	3	4	5	6	7
I	a		b	c		d
I		e					f
II				D	E
II	A	B	C				F

Output:

FieldName	1	2	3	4	5	6	7
I	a	e	b	c		d	f
II	A	B	C	D	E		F

[binuacs]

@IMSL One way of doing this

[IMSL · Accepted solution]

I had to use summarize tool! :D

[DataNath · Accepted solution]

@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:

[caltang]

Like this: