How to have items belong to multiple different categories and then be able to filter.

%3CLINGO-SUB%20id%3D%22lingo-sub-3350884%22%20slang%3D%22en-US%22%3EHow%20to%20have%20items%20belong%20to%20multiple%20different%20categories%20and%20then%20be%20able%20to%20filter.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3350884%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20a%20database%20of%20different%20pet%20foods.%3C%2FP%3E%3CP%3EI%20want%20to%20be%20able%20to%20add%20multiple%20categories%20that%20belong%20to%20one%20'group'%20to%20each%20product%20then%20filter%20using%20those%20categories.%26nbsp%3B%3C%2FP%3E%3CP%3EMost%20products%20are%20used%20for%20treating%20multiple%20issues%2C%20I've%20made%20a%20table%20with%20what%20each%20of%20them%20are%20for%20but%20I%20want%20to%20be%20able%20to%20easily%20filter%20for%20which%20products%20treat%20kidney%20issues%20for%20example%20without%20having%20an%20incredibly%20wide%20table.%20Is%20this%20possible%3F%20It%20feels%20like%20it%20should%20be%20but%20I%20just%20don't%20know%20where%20to%20start.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Dog%20food.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370469iDBA24B5BF7F0B967%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Dog%20food.PNG%22%20alt%3D%22Dog%20food.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3350884%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3351219%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20have%20items%20belong%20to%20multiple%20different%20categories%20and%20then%20be%20able%20to%20filter.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3351219%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20might%20consider%20tabling%20the%20data%20and%20then%20adding%20a%20slicer%20(or%20two).%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d%3Fmsclkid%3D557d31b2d06a11ecb8b74e1c2f33f825%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d%3Fmsclkid%3D557d31b2d06a11ecb8b74e1c2f33f825%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20option%20is%20to%20create%20a%20pivot%20table%20(The%20data%20would%20have%20to%20be%20un-pivoted%20with%20PowerQuery%20first).%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3351310%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20have%20items%20belong%20to%20multiple%20different%20categories%20and%20then%20be%20able%20to%20filter.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3351310%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1385903%22%20target%3D%22_blank%22%3E%40PistachioFace%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EWhile%20I%20can't%20follow%20why%20you%20don't%20use%20filters%20and%20create%20a%20table%20from%20them%20beforehand%2C%20I'll%20send%20you%20these%20links%20with%20the%20information%20that%20might%20help%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-table-in-excel-bf0ce08b-d012-42ec-8ecf-a2259c9faf3f%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ecreate%20and%20format%20a%20table%3C%2FA%3E%2C%20to%20visually%20group%20and%20analyze%20data.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffilter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EFilter%20data%20in%20a%20range%20or%20table%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EUse%20slicers%20to%20filter%20data%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EAt%20the%20same%20time%2C%20with%20your%20permission%2C%20I%20would%20like%20to%20recommend%20that%20you%20include%20information%20about%20your%20digital%20environment%20in%20advance.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EInform%20about%20your%20Excel%20version%2C%20operating%20system%2Fnetwork%2C%20storage%20medium%2C%20etc.%20.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EIf%20possible%2C%20attach%20a%20file%20and%20use%20this%20file%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E(Drag%20and%20drop%20here%20or%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Freplypage%2Fboard-id%2FExcelGeneral%2Fmessage-id%2F145877%23%22%20target%3D%22_blank%22%3Ebrowse%3C%2FA%3E%20files%20to%20attach%20Maximum%20size%3A%2071%20MB%20)%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3Eto%20explain%20your%20intention%20step%20by%20step%2C%20so%20you%20can%20get%20a%20possible%20solution%20much%20faster%20and%20more%20accurately...%20and%20the%20helper%20is%20not%20forced%20to%20make%20assumptions.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm trying to create a database of different pet foods.

I want to be able to add multiple categories that belong to one 'group' to each product then filter using those categories. 

Most products are used for treating multiple issues, I've made a table with what each of them are for but I want to be able to easily filter for which products treat kidney issues for example without having an incredibly wide table. Is this possible? It feels like it should be but I just don't know where to start.  

Dog food.PNG

2 Replies

You might consider tabling the data and then adding a slicer (or two).

https://support.microsoft.com/en-us/office/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-126517...

 

Another option is to create a pivot table (The data would have to be un-pivoted with PowerQuery first).

@PistachioFace 

While I can't follow why you don't use filters and create a table from them beforehand, I'll send you these links with the information that might help you.

 

You can create and format a table, to visually group and analyze data.

Filter data in a range or table

Use slicers to filter data

At the same time, with your permission, I would like to recommend that you include information about your digital environment in advance. Inform about your Excel version, operating system/network, storage medium, etc. .

If possible, attach a file and use this file (Drag and drop here or browse files to attach Maximum size: 71 MB ) to explain your intention step by step, so you can get a possible solution much faster and more accurately... and the helper is not forced to make assumptions.

 

Hope I was able to help you with this info.

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)