Going through a List

Is it possible in app sheets to go through a column of lists and add something to each item?

EX:

Test ID : TS_Security
List: {Item 1, Item 2, Item 3}

I want the list to be: {TS_Security:Item 1, TS_Security:Item 2, TS_Security:Item 3}

Something like this?

SPLIT(
  "TS_SECURITY:"
  &
  SUBSTITUTE(
    CONCATENATE( old-list ) ,
    "," ,
    ", TS_SECURITY:"
    ),
  ","
)
2 Likes

That’s exactly what I needed, thank you so much for your help

2 Likes