How to add multiple hyperlinks for each value within a cell of a table?

[Manu Swami]

Hello,

Wondering if anyone can help me with a query. 

I have created a report by majorly using spreadsheet, Pivot table, Table Transformer macros. My report finally creates a table with some values. In some rare cases, few columns may see multiple values in a cell (because I have grouped by first column) which is completely fine to me. 

The Pivot table output for the rare case is similar to below:

column 1	column 2	column 3
Group By values of column1	1234 6789	forurl1 forurl2

The problem now is, when I wrap the Pivot table output in Table Transformer macro and concatenate a website address prefix with column 3 using formatwiki, I get a single combined link in the output (single hyperlink with the prefix I have provided and the combined values of column3) in the following manner:

FORMATWIKI(" [" + T1.’column3’ + "|https://websitelink” + T1.'column3' + "]\n") AS 'column3',

column 1	column 2	column 3
Group By values of column1	1234 6789	websitelinkforurl1websitelinkforurl2

I understand that the formatwiki is treating all cell values as one and applying the logic but still is there a way I can get two hyperlinks in column 3 cell for both the values like below?

column 1	column 2	column 3
Group By values of column1	1234 6789	websitelinkforurl1 websitelinkforurl2

Note that websitelink prefix is common for both forurl1 and forurl2 values.

Thanks in advance- Manu