Another solution.
This is maybe easier for people not familiar with BP that much. This solution was suggested by my colleague.
The idea is, that we replace SEMICOLON with new line feed, so we get comma separated values for each entry on separate row....
As for your latest reply with the expected output..
Apply the advice I gave you, i.e. split single input from the collection, using comma as delimiter.
Example: ""last name, first name, email@mail.com"" should result in ""last name "", ""first name "...
Simply use Utility - Collection Manipulation, action Append Field (text), where you specify Collection to modify and name of the column as Field Name parameter. You can leave Value parameter empty - read the documentation for the action, if more info...