Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
Apr 30, 2025
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...
excel
  • m_tarler's avatar
    m_tarler
    Apr 30, 2025

    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:

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 30, 2025

SergeiBaklan 

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?

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 30, 2025

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.

Resources