The Split Text column splits up text by a value of your choosing. For example, say we have a list of people separated by commas.
Marie Rao, Tamsin Woodward, Alan Eijk, Fo Lambert, Christina Wallace, Ryan Holbert
Because this value lives in a single cell, Glide sees it as a single value. However we can split it up by the commas.
When we do this, we end up with a new column with multiple values.
Because this is a computed column, we can't then show that column in our Google Sheet, however, we can, for example, use it in a relation.
In the image below we have created a relation column with the joined list column which relates all employees who are attending this meeting.
We can now create an inline list inside a meeting which shows all the participants, and all we had to start with was a single cell of data! You can even show this cell in your app and allow people to add new values.