Concatenate rows into one row by value of a column

[eyalgrn]

Hello,

I am trying to concatenate several rows into one row, so several cells in same column but different rows should go into one cell. The grouping should be done by the value of another column.

Here is the data. So all the values in cells C2, C3 and C4 (same item - "XZR") should be concatenated into one cell - C20. The same is for each of the items ("XZR", "AWE" and "TUP"). Please note that I need to show them in a separate lines within the new cell (so I also need to concatenate them with a line break, as shown in the example). 

I appreciate your help!

Thanks,

Eyal

[jrgo · Accepted solution]

@eyalgrn,

You can use a Summarize tool to concat values from rows

[eyalgrn]

Perfectly works!! Thanks!

[Present_guy]

thank you -- just what I needed

[subhajits11]

thank you

[akumar14]

Hi,

In the above example if in item details, same value is appearing multiple times and I want to concatenate only distinct values, how can we do that?

Thanx

[subhajits11]

Can you try "Unique" tool to achieve that for the [Column name].