Merge/Group & keep Format through Table transformer

Question

Hello everyone,

I would like to see if exist the possibility through Table tranformer to group cells and keep them in some way to the format:

For example having a initial table like this:

Have a final table like this:

I know Pivot is a possible solution, but is messing with the final format that I want to get.

Example of how I dont want to have my table:

Nikita Kamai_cmnxee · Answer

Hello,

I am Nikita from Stiltsoft.

Please, check how this SQL query helps you out - simply place it inside our macro SQL query field and save:

CREATE TABLE TX;
INSERT INTO TX
SELECT ROWNUM() as 'id', * FROM T1;

SELECT 
CASE WHEN 'id' IN (SELECT MIN('id') from TX GROUP BY 'Column 1') THEN 'Column 1'
ELSE FORMATWIKI("{cell:border-top-color: white; border-top-width: 2px;}", NULL, "{cell}") END as 'Column 1', 
'Column 2','Column 3'
FROM TX

Best wishes,
Nikita