pjmthissen
New Member
- Joined
- Jan 10, 2018
- Messages
- 4
Hi folks,
I have i list that shows in column A the title and in column B the topic.
This list is generated by an external system and unfortunately that system generates a new row in case a title has multiple topics.
I want generate list that has no duplicate titles and shows the topics concatenated in case a there are multiple topics per title.
In case I manage to get something like the below example I can use the remove duplicates functionality to get a list without duplicate titles.
Or is it possible to do both; concatenate the topic and remove a duplicate row in one go?
An example:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thanks in advance.
I have i list that shows in column A the title and in column B the topic.
This list is generated by an external system and unfortunately that system generates a new row in case a title has multiple topics.
I want generate list that has no duplicate titles and shows the topics concatenated in case a there are multiple topics per title.
In case I manage to get something like the below example I can use the remove duplicates functionality to get a list without duplicate titles.
Or is it possible to do both; concatenate the topic and remove a duplicate row in one go?
An example:
Title | Topic | Concatenated topics |
CRD / Light Production Business – REFRESH | S&M - DS | S&M - DS; S&M - BIS |
CRD / Light Production Business – REFRESH | S&M - BIS | S&M - DS; S&M - BIS |
Purchase to Pay Curriculum | S&M - DS | S&M - DS |
DS Managed Services Training Presales | S&M - DS | S&M - DS |
Negotiation and Closing of Business Cases | S&M - DS | S&M - DS; S&M - SB&S; S&M - IPS |
Negotiation and Closing of Business Cases | S&M - SB&S | S&M - DS; S&M - SB&S; S&M - IPS |
Negotiation and Closing of Business Cases | S&M - IPS | S&M - DS; S&M - SB&S; S&M - IPS |
Advanced economics - deepen accounting fundamentals | S&M - DS | S&M - DS; S&M - LFP |
Advanced economics - deepen accounting fundamentals | S&M - LFP | S&M - DS; S&M - LFP |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thanks in advance.