Pivot table solution? Please help!

[David77]

Hello everybody,

I am currently managing a list of materials for different sections:

The top of the list looks like this:

I have about 6 sections (EM, Formulering, Inspektion & more - please let me know if you want all the names).

I want to create some sort of pivot table (I assume? I have never made or dabbled in pivot tables before in my life) so you have a Slicer in Excel, where you can select the section, such as "EM" and then only all of the materials who begins with "EM" will show up on the list.

Finally, I also have 10 materials who are unbranded (not named with a section such as "EM - Material xxx" but simply just "Material xxx"). Is there a way to combine them into a section called "General goods" in the slicer?

I would truly appreciate any help that I can be offered in this task! I would be absolutely amazing if someone could lend me their time here.

Thank you so much everybody

Best regards,
David

 

[sandy666]

post representative example of source data using xl2bb or link to the shared excel file with representative example using onedrive, googledrive, dropbox or any similar service

 

[sandy666]

it was done with data from pictures so it may not be very correct

s666-PQ-Pivot-david77.xlsx

Microsoft Excel Workbook

1drv.ms

 

[ebea]

Isn't it the same question as this in the Link below, just in another way?

Alphabetically order a list with respect to column B

Hello everybody, I have the following list of information: Is there any way in which I can alphabetically order this list with respect to column B? Would greatly appreciate any assistance I can obtain! :) Thank you very much everybody. Best regards, David

www.mrexcel.com

 

[David77]

Isn't it the same question as this in the Link below, just in another way?

Alphabetically order a list with respect to column B

Hello everybody, I have the following list of information: Is there any way in which I can alphabetically order this list with respect to column B? Would greatly appreciate any assistance I can obtain! :) Thank you very much everybody. Best regards, David

www.mrexcel.com

Hello ebea,

I understand your confusion, but no, it is not. Here I want to somehow filter them into group categories, so only some are visible depending on which area you pick in the slicer.

In the order I just wanted to sort the entire data

Appreciate it!