Power query output not showing count of blanks in pivot table

Hey everyone. I’m normally a python guy but today i figured I’d try to use power query to combine 4 files with identical structure. Then a simple pivot table where the blanks mattered. The pivot table showed the blank row category but nothing for the counts of the blanks. Baffled, i asked chariot because i was in a rush. ChatGPT re-wrote the M-code replacing blanks with actual text named “Blank”. Then it worked. Is this a power query quirk? My boss copy and pasted the data to append it and it was fine when she made her pivot.