Forum Discussion
Pivot Not Grouping
The problem is that some of the "SWAP " have a space after the word and others do not
I did a Find & Replace to remove the extra space and refresh the table and it worked perfectly:
thank you very much. I thought about that and did check some records but I thought it would ignore the extra space so I didnt continue searching teh records for the spaces. This si good to know.
I do see that Sergei responded that if I used the Data MOdel it would have trimmed the extra space automatically. I am using Power Query and I will now trim it automatically but will change the data source as well. thank you much!
As a comment, if load Power Query into data model extra spaces also will be trimmed. However, better to do that explicitly within the query.