Joined list to Column for colection

Ask for Help
1

Good afternoon everyone.
Can you help me transform an array made with joined list into a column.
Example
Joined List
Banana,Avocado,Orange.
Fruits Column
Banana
Avocado
orange.
Is this possible?

2
  • Number your rows, starting at 0
  • Coerce your list into an array using a Split Text column
  • Apply the array to every row using a Single Value->First column
  • Use a second Single Value column to extract the Nth from start of the previous column, where N is your row number
2 Likes
3

It didn’t work.
Can you make an example, please.

4

Can you show where you got stuck?

5

Good afternoon,
What happened was that I had 4 items to use in the single value and I put the sequence from 0 to 3, however, the database had 20 rows and I discovered that if they didn’t number them from 0 to 19, I would get an error. I managed to resolve it.
Thanks everyone.

2 Likes
6

Dont need to use split text.