BUG: DataFrame.pivot not respecting None as column name
- [ ] closes #xxxx (Replace xxxx with the Github issue number)
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

Columns can never be empty when called by the user, should we deprecate positional arguments here and then remove the default? avoids the check on our side and simplifies things a bit
> Columns can never be empty when called by the user, should we deprecate positional arguments here and then remove the default? avoids the check on our side and simplifies things a bit

+1 for this.  Will open a pr to backport to 1.5rc then, will convert this to draft till the other pr is merged then to simplify the backport  cc @mroeschke  I think this is ready for another look now Thanks @phofl 