Trim Spaces out of concat column with this code DAX - Power Query

Use this is you are concating multi columns and need to remove unwanted spaces from the concat column

IE: I was concating address fields like so 
[ITSP Street Address] & " " & [ITSP Apartment Number] & " " & [ITSP City] & " " & [ITSP State] & " " & [ITSP Zip Code]

Sometimes the [ITSP Apartment Number] column did not have a value so it added an extra space for the column.

Here's how you get rid of the extra spaces with a Trim.

Text.Combine(List.RemoveItems(List.Transform(Splitter.SplitTextByCharacterTransition({" ", ","},(a)=>not List.Contains({" "},a))([YOURCONCATCOLUMN]), each Text.Trim(_)),{"",","})," ")