Forum Discussion
Solved
Pivot Not Grouping
Hello Experts, I am trying to group a simple data set. I have 2 Columns: Deposits and Withdrawals I need to Group on SWAP. It doesnt group for some reason. Do you see why its not gro...
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:
If creating PivotTable you add data to data model (if you are on Windows)
texts will be trimmed automatically while loading to data model, thus no additional actions are required
texts will be trimmed automatically while loading to data model, thus no additional actions are required
I didn't know that. Is this docmented somewhere?
Detlef_Lewin , I found that eventually, have no idea is it documented or not. Perhaps that was from scratch since above works on Excel 2019 as well.