DOC: Enhancing pivot / reshape docs
- [x] closes #19089 
- [x] tests added / passed (NA Just Docs)
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [x] whatsnew entry

Enhancing pivot / reshape docs

Added more examples and added Q + A section.