Merge cells with table transformer

[Megan]

I want to merge cells that have the same value, but allow each of the rows after the initial column to be separate. Is this possible?

Ive tried this SQL, but it merges the columns into one row - i'd like "Strategic Initiative" to be merged when matched, but the summary to remain in separate rows so the information can be filtered out more easily.

SELECT T1.'Strategic Initiative', T1.'Summary',
FORMATWIKI(SUM(T1.'Summary' + "\n")) AS 'Project'
FROM T1
GROUP BY T1.'Strategic Initiative'

[Stiltsoft support]

Hi @Megan ,

Here is a screenshot for the better understanding of the case:

If we talk about the option 1, then it is not possible to implement.

The option 2 is a standard variant of data aggregation via the Table Transformer macro that you seem try to achieve with your query.