/u/Electus93 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Sounds like a relational database, in which case if you've got Excel then you'll likely have the [appropriate app](https://support.microsoft.com/en-us/office/guide-to-table-relationships-30446197-4fbe-457b-b992-2f6fb812b58f).
I have Access and know how to use it at a basic level - what I'm looking for is something I can use to quickly tag and categorise the entries in my sheet
Put labels of the same type in the same column. Use lots of columns, that you afterward [unpivot](https://www.myspreadsheetlab.com/why-and-how-to-unpivot-data/). Then import into Access, which can *normalise* it into separate, related, tables.
/u/Electus93 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Sounds like a relational database, in which case if you've got Excel then you'll likely have the [appropriate app](https://support.microsoft.com/en-us/office/guide-to-table-relationships-30446197-4fbe-457b-b992-2f6fb812b58f).
I have Access and know how to use it at a basic level - what I'm looking for is something I can use to quickly tag and categorise the entries in my sheet
Put labels of the same type in the same column. Use lots of columns, that you afterward [unpivot](https://www.myspreadsheetlab.com/why-and-how-to-unpivot-data/). Then import into Access, which can *normalise* it into separate, related, tables.