BUG/WIP: fix pivot with nan indexes

closes #7466

- [ ] vbench
- [ ] make sure there isn't a better way to do this