Transform data: concatenate fields based on groups

I read from database and have resulting query data like:

Group Value
1      A
1      B
2      A
2      C

I would like to transform to:

Group Sequence
1     AB
2     AC

What is good way to do this in KNIME? Thank you!

Use the "Group By" node with "Concatenate" as aggregation method. The separators added by this step can be removed with e.g. the String replacer node.

thor, this worked perfectly. Thank you!