Confluence Table Transformer - Keep Jira Summary Hyperlink when merging cells

[Megan]

I'm using Confluence table transformer.

I am merging cells together to create a table view grouped by certain properties. In the second column is the issue summary, which is being grouped based on another dimension. In order to do this I've found I need to use FormatWiki. When I do this I lose the link to the summary / jira issue. Is there a way to keep this?

Here is what I'm inputting to merge the cells based on the first column. As you can see in the screenshots, it results in a lost hyperlink to the ticket. I'd like to retain the links but otherwise keep things the same.

SELECT 'Strategic Initiative' as 'Initiative', 'Summary' as 'Projects+', 'Stage', 'Target Start', 'Product Sponsor' AS 'Product Strategy', 'Product Owner' as 'Planning & Roadmap',
FORMATWIKI(SUM(T1.'Summary' + "\n")) AS 'Projects+'
FROM T1
GROUP BY 'Strategic Initiative'

[Stiltsoft support]

Hi @Megan ,

You may use the Pivot Table for the case as for now.