Insert bulk rows in another table using list values from a column

[tecpme_casm]

Is it possible to insert a list of key values in a column like: s0dk3jf9,10dkfiMd,spzi20dm,0cmap2la,0dm58djf and build an action that inserts a row in another table based on those values?

The bulk insertion is to register about 300 or 200 people attending an event and for that amount of people I need a quick way to insert them given that they will attend the same event monthly

The result on the table [attendance] will be something like:
id member activity
uniqueid() s0dk3jf9 aosucnsp
uniqueid() 10dkfiMd aosucnsp
uniqueid() spzi20dm aosucnsp