M: Split column with multiple spaces between fields

One way to do this is to split the text into a list based on the delimiter, remove nulls, and then recombine the list into a string with just a single space between words.

= Table.TransformColumns(Source, {{"Column1", each Text.Combine(List.Select(Text.SplitAny(_, " "), each _ <> "")," "), type text}})

or in expanded format

= Table.TransformColumns(
      Source,
      {{"Column1",
          each Text.Combine(
                   List.Select(
                       Text.SplitAny(_, " "),
                       each _ <> ""
                   )
                   ," "
               ),
          type text
      }}
  )

Then you can split this transformed column by the space delimiter.