how to merge row cell by SQL

[huangbin chen]

I would like to merge row cells

Is there SQL language can support this? I would like to do this by SQL automatically.

I saw example here, but seems cannot work correctly on Confluence "Table Transfomer" Macro

https://partners-intl.aliyun.com/help/en/maxcompute/latest/merge-multiple-rows-of-data-into-one-row

Thanks

[huangbin chen · Accepted solution]

Find answer here

https://community.atlassian.com/t5/Confluence-questions/Table-Transformer-Merge-Cells-with-Duplicate-Rows/qaq-p/1685132

Result:

Result:

[Katerina Kovriga {Stiltsoft}]

Hi @huangbin chen ,

Due to the time zone difference you've already found a solution - glad that everything is working fine for you!

Thank you for using our Table Filter and Charts for Confluence app!