Remove trailing spaces

Hello, 

How could I remove the trailing spaces in my table field named Vendor?  

I can filter for vendors with a space at the end but I dont know how I can remove the space at the end.  

I am not sure what else woudl need to be know but feel free to reach out.  

I know I can use trim in excel but I want to use power query to do this. 

I am a novice user. 

thank you