Concatenation of Values in Rows

[Nandakishore]

Hi ,

Is there any way to concatenate the values available in multiple row of a given column using Multi row formula expression . 

Thanks

[binuacs]

@Nandakishore 

[Christina_H]

Here's a few different options, using either summarise or multi-row formula.  I've applied the same methods to two different sets of data you provided.  They should all continue working if there are more rows with the same unique ID.

[Nandakishore]

Hi @Christina_H and @binuacs  ,

Thankyou for the help . But it does not work with Multi row formula . 

@binuacs   , you logic for only for 2-3 rows . Can you help to do the same for any number of row .

Thanks.

[binuacs]

@Nandakishore if you have more rows you need to adjust the multi-row tool num or rows and the expression

[Christina_H]

Using that method in the multi-row formula, it will never work for any number of rows.  The formula has to explicitly include each row.  There has to be a maximum number it will work for, which is the number you've included in the formula.

Can you show what your results are so we can figure out what isn't working?