List of list of numbers to list of numbers

[Djigi]

Hi,

I have used SELECT to get a column from certain rows. This column contains a list of numbers. The SELECT function gives me a list of list of numbers while it should be a complete list of numbers of all the lists. 

So to clarify, SELECT results in multiple lists of numbers:

LIST(1, 2, 3), LIST(4, 5, 6), LIST(7, 8, 9)

I would like it to result in:

LIST(1, 2, 3, 4, 5, 6, 7, 8, 9)

I hope I've explained it well. Does anyone know how to do this?

[Suvrutt_Gurjar · Accepted solution]

Generally you can use a SPLIT() function to get list from list of lists.

So something like 

SPLIT(SELECT(Table Name[List of Numbers column ], conditional expression for SELECT()), ",")

SPLIT() - AppSheet Help

[Djigi]

Thank you!