Welcome to the community, @Crispin_Giles!
Conditional hiding & showing of fields is only possible on a form, and then when the user submits that form, a new record will be created in your table.
Otherwise, if you’re not looking to create new records via a form, you would need to manually create different views where each view would be manually set by you to have its own set of hidden fields. And then you would manually need to switch back & forth between those views to see the set of fields that are on each view.
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. If not, please let me know what else you need help with!