Split Columns

Hope this helps!

The below approach is one of the simplest approach ... (, may be better approach exists)...

  1. Duplicate the column and use this column

  2. Split the column for the last word i..e, using Split using "Space" and "Right-most delimiter"

  3. Split the first column from (2) for the last word

  4. Merge the last two columns

Optional:

  Rename the columns "Merged" and "Column1 - Copy.1.1" to your needs. 

Roughly,

....
    #"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "Column1", "Column1 - Copy"),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Duplicated Column", "Column1 - Copy", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Column1 - Copy.1", "Column1 - Copy.2"}),
    #"Split Column by Delimiter1" = Table.SplitColumn(#"Split Column by Delimiter", "Column1 - Copy.1", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Column1 - Copy.1.1", "Column1 - Copy.1.2"}),
    #"Merged Columns" = Table.CombineColumns(#"Split Column by Delimiter1",{"Column1 - Copy.1.2", "Column1 - Copy.2"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Merged")
in
    #"Merged Columns"

Regards