Split multi value cellson Google Spreadsheets

Question

I have a Google Spreadsheet that record information in 3 columns. The first columns record in one cell several names separated by ;, like this:

A                                                   B       C
Mieke Jans;Jan r Werf;Nadine Lybaert;Koen Vanhoof   2011    Belgium
Alessandro Stefanini;Davide Aloini                  2020    Italy
Worarat Krathu;Davide Aloini;Robert Engel           2014    Austria
Jasmien Lismont                                     2016    Belgium

I want to apply a function to column A such that the function splits the information on the ;. Something like:

=SPLITTING_FUNCTION(A:A)

that results in

Mieke Jans
Jan r Werf
Nadine Lybaert
Koen Vanhoof 
Alessandro Stefanini
Davide Aloini
Worarat Krathu
Davide Aloini
Robert Engel
Jasmien Lismont

Please observe that column A stores a variable number of names. Also, names can repeat. How can I do that?

Answer 1

You can JOIN all the values in the range together by ; and then SPLIT them by ;:

=transpose(split(Join(";",transpose(A1:A)),";"))