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 |
Solved! Go to Solution.
I had to use summarize tool! :D
@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: