Forum Discussion
How to split the the Column into Multiple rows.
Hey,
in the query editor, I just marked the column and from the context menu of the marked column I chose "Split Coliumn" -> "By Delimiter"
From the dialog I chose Advanced Options as shown below
This leads to the following result
Hope this is what you are looking for
Regards
Tom
Hey,
in the query editor, I just marked the column and from the context menu of the marked column I chose "Split Coliumn" -> "By Delimiter"
From the dialog I chose Advanced Options as shown below
This leads to the following result
Hope this is what you are looking for
Regards
Tom
Hi,
May I know how to do this reverse, like below
Table
---------------------------------------
Col1 Col2 Col3
1 2019 ab
2 2019 xy
3 2018 zd
4 2017 rt
5 2019 rt
6 2017 cv
O/P should like
--------------------------------------------
Col1 Col2 Col3
1 2019 ab,xy,rt
2 2019 ab,xy,rt
3 2018 zd
4 2017 rt,cv
5 2019 ab,xy,rt
6 2017 rt,cv