Concatenate - Report Text Tool

[giulianosua1]

Hi - I have the following situation: 

Raw Data: 

STORE NAME	PRODUCT	CONTACT
Oxford	Apple TV	Jon Doe
Oxford	Samsung Phone	John Smith

What I am trying to achieve in Email format: 

STORE NAME	COVERAGE
Oxford	Apple TV: Jon Doe; Samsung Phone: John Smith

The issue of the above, is that I just want the product in bold and ideally in a colour. I have seen solutions in other discussions, that seems to be around using REGEX, but I am not sure it that will cover. 

Some things to know, the number of products per store may vary (will come from an excel) and same as the coverage. 

The output is a table in an email. 

Any help would be highly appreciated!

Alan

[DavidP · Accepted solution]

Hi @giulianosua1 

How about something like this?

[giulianosua1]

Thanks @DavidP!