Use ARRAY_AGG to flatten columns to lists.

You need to convert a long table of values into a list? This is the most convenient function.

πŸ“Œ Syntax:
πš‚π™΄π™»π™΄π™²πšƒ π™°πšπšπ™°πšˆ_𝙰𝙢𝙢(πšŒπš˜πš•πšžπš–πš—) π™΅πšπ™Ύπ™Ό πšπšŠπš‹πš•πšŽ

There you go, the column is flattened into a list separated by comma.

❌ To do so, I used to copy the entire column into a spreadsheet tool, transpose it, and use some Excel magic to convert it to a list. And I'll never do it again.

You can use it with GROUP BY and get separate lists! Full example below.