Concatinating rows depending on certain condition

cycyg

Hello community!!

Would appreciate any help for the below problem since I could not find any similar questions on the community.

I am trying to concatenate the description values as shown in input screenshot below to reach the output screenshot. It is not always the same spacing between the amounts. 

Input:

Output:

Kenda

Hello @cycyg 

There are two ways that come to mind to solve this. Depending on the rest of your dataset, choose whichever one fits your needs the best.

1. Use a multi-row formula tool to update the Amount field to "fill down" the missing values with this expression:

iif(isempty([Amount]) && [Value]=[Row-1:Value] && [Type]=[Row-1:Type], [Row-1:Amount], [Amount])

Then use a summarize tool to concatenate the description field and group by the rest.

2. You can use a summarize tool to concatenate the description field, take the first for the amount field, and group by the rest.