Create Headings from Column Data

[alphag_25]

Hello all,

Great forum!!

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

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

I wish to create grouped headings for item to be created by the colum
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 t
data and then sort by item number.

Thanks,

Geof

 

[MartinW]

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