Change the order of text in a column

[sara11]

I have a column with text like this:

Kristof, I., Apud, G.R., Aredes-Fernández, P.
or
Wacker, M., Keiser, J., Hirt, B., Stahl, M., Scharfenberger-Schmeer, M., Durner, D.
or
Yem, O., Petrie, P.R.

and I'd like to change this text to

I. Kristof, G. R. Apud, P. Aredes-Fernández
M. Wacker, J. Keiser, B. Hirt, M. Stahl, M. Scharfenberger-Schmeer, D. Durner

O. Yem, P. R. Petrie

i.e. the first names appear first, followed by the surname. The authors' names are separated by ",".

Thank you.

[slorin · Accepted solution]

Hi, @sara11 

Text.Combine(
    List.Transform(
       List.Split(Text.Split([Your_Column],", "),2),
       each Text.Combine(List.Reverse(_)," ")),
    ", ")

Stéphane

[sara11]

Thank you! It worked!