How to combine text across 3 records that share a common id

[hellyars]

How can I combine text (descriptions, 1 for each year) across 3 records that share a common task Id? 

Individually, I know the Summary tool can be used to sum the values across years.  But, how can I combine the descriptions into one field (separated by the year - as text)? 

FROM -->

Task	Description	2016	2017	2018
N-002	yada yada yada	24	0	0
N-002	blah blah blah	0	18	0
N-002	yap yap yap	0	0	29

TO -->

Task	Description	2016	2017	2018
N-002	2016:  yada yada yada; 2017:  blah blah blah; 2018: yap yap yap	24	18	29

[Claje · Accepted solution]

Hi,

I've attached an example workflow with two methods that solve this problem.  The top method is "Static".  It works only for the years 2016, 2017, and 2018, and would need to be actively touched to work in the future, as the formula and summarize will not work for other values.  However, it is a pretty simple option (two formulas and a Summarize).

The bottom example is "Dynamic", and will work for any set of years (and any number of years).  It should work regardless of any other changes, so it will work just as well in 2019 as it does today.

This option is somewhat more complex (I used 7 tools to make it), but should take less maintenance.

I hope this helps!

[ponraj · Accepted solution]

Here is the sample workflow for your case. Hope this is helpful. 

WorkflowResults