Separate Selections

[tvinci]

Hello AppSheet Community,

I am making a driver dispatch app where the dispatcher can create routes from a master database of locations. The routes then become part of driver’s “clipboards.” The problem is the clipboard view of the routes looks like this

Screenshot 2020-04-16 12.48.19.png

1 of 1

95%

I want it to look like this

I can get it the way I want to look with some transpose(split(text, “,”)) function on the back end, but I don’t know how to automate that transpose/split function to get every route entry looking more like a clipboard (like the second picture). Every time a user makes a route with multiple locations, I want the locations separated in their own row in the database, not all populated together in one cell. How do I do this?

Thanks!