Bug #449 tidyr complete

[seabbs]

PR aimed at fixing #449. Change in tidyr has broken both functionality and tests.

[github-actions[bot]]

👋 Thanks for opening this pull request! Can you please run through the following checklist before requesting review (ticking as complete or if not relevant).

• [ ] Read our contribution guidelines if you have not already done so.
  • [ ] If you have altered an existing class please run the tests locally (using devtools::load_all(); devtools::test()) first setting options(testDownload=TRUE, testSource=class-name) and report your findings.
  • [ ] If you have added a new data class please run the tests locally for that class (using devtools::load_all(); devtools::test()).
  • [ ] Check your code passes our CI checks and review any style and code coverage warnings.
  • [ ] Comment with details if unable to get our CI checks to pass or unable to remove all warnings.
  • [ ] Update the news file with information on your changes (crediting yourself at the same time)

Thank you again for the contribution. If making large scale changes consider using our pre-commit hooks (see the contributing guide) to more easily comply with our guidelines.