Hi, I have Data in 2 rows. I want Data to be in One row. Below is the Example

[Ayaanarjun-5885]

Input

Fruits	Count
Apple	10
Banana	5

Output:

Fruits	Count
Apple & Banana	15

[Prometheus · Accepted solution]

@Ayaanarjun-5885 There's probably a better way to do this, but I just split your data into two streams -- one with Fruits and one with Count. Then I concatenated Fruits with " & " as the delimiter and summed Count then brought them back together with an Append Fields tool.

[Jeff_Neklason]

@Ayaanarjun-5885 You can also do this using the Summarize tool in a single step. You will want to include spaces in the Concatenate Properties configuration " & ".