So I have data as follows: All I would like to do is make a new table which gathers all text into one cell as follows: So all values of tags are in one cell for each ID. Order does not matter, but they must be separated by commas. Answer how about this :

How to add all text in a column into one cell in Snowflake

So I have data as follows:

ID   tags
001  apple, banana
001  NA
002  berry, blue, banana
003  melon, apple, grape
002  grape
001  apple, banana
001  grape

​x
 
ID   tags001  apple, banana001  NA002  berry, blue, banana003  melon, apple, grape002  grape001  apple, banana001  grape​

All I would like to do is make a new table which gathers all text into one cell as follows:

ID   tag_full
001  apple, banana, apple, banana, grape
002  berry, blue, banana, grape
003  melon, apple, grape

 
ID   tag_full001  apple, banana, apple, banana, grape002  berry, blue, banana, grape003  melon, apple, grape​

So all values of tags are in one cell for each ID. Order does not matter, but they must be separated by commas.

how about this :

select id , listagg(tags , ',') as tag_full
from tablename 
where tags <> 'NA'
group by id

 
select id , listagg(tags , ',') as tag_fullfrom tablename where tags <> 'NA'group by id ​