Concatenate rows into one row by value of a column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you try "Unique" tool to achieve that for the [Column name].
