Does exist an aggregate function that work as opposite of Flatten?

[anitelleth]

Hello guys. I’m looking for a way to LISTAGG the results of a query.

I’ve noticed that to do the opposite of that, we can use regexp_split() + flatten() and get things done. Thus, if we could de-flatten a dataset would be very nice.

Line break or Single row to multiple rows

Dear all, I need a sample select statement query for Line break(Single Cell value split in to Multiple Rows). Example, Input: ID Comment 1 Test1 Test2 Test3 Output: 1 Test1 1 Test2 1 Test3 Thanks,