Create Headings from Column Data

Hello all,

Great forum!!

My question is that i have a excel shreadsheet that is a list of part numbers, part name, prices and category.

I can do a sort of the spreadsheet by category and sort all data to be grouped by category and in order of part number.

I wish to create grouped headings for item to be created by the column data

Part No, Price, Part Name, Category
CBL10MM2C, $10.47, 10mm˛ Twin Flat, Cable
CBL10MM2CX5, $13.74, 10mm˛ Twin Flat (Cut), Cable
220/25GY, $2.04, 25mm PVC GY Plain Bung, Conduit
AD810T, $55.42, 10A 2pole 4.5Ka RCD/MCB Combo, Circuit Protection

Can I do a sort to create:

Part No, Price, Part Name, Category
Cable
CBL10MM2C, $10.47, 10mm˛ Twin Flat, Cable
CBL10MM2CX5, $13.74, 10mm˛ Twin Flat (Cut), Cable
Conduit
220/25GY, $2.04, 25mm PVC GY Plain Bung, Conduit
Circuit Protection
AD810T, $55.42, 10A 2pole 4.5Ka RCD/MCB Combo, Circuit Protection

Like in microsoft access where you sort and give a group heading to data and then sort by item number.

Thanks,

Geoff

Hi Geoff,

Similar to Dan in the thread above, you need to use autofilter,
then copy and paste to a new location.
Select your 4 name cells and goto data>autofilter and
follow your nose from there.

HTH
Martin