Trim and Clean not working to remove hidden space/row from SharePoint list data set

Actually when you paste the data, then you will lose whitespaces. Hence, from pasted data, it is not possible to know what whitespaces are there. While it will need the sample data to see what whitespaces are there but there is another way to retrieve what you want. Since you have only text and numbers to be retrieved+space, Just insert following statement where data is the column which has Example A, Example B results and Source is your previous step

= Table.ReplaceValue(Source,each [data],each Text.Select([data],{"0".."9","a".."z","A".."Z"," "}),Replacer.ReplaceText,{"data"})