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


--
alphag_25
------------------------------------------------------------------------
alphag_25's Profile: http://www.excelforum.com/member.php...o&userid=35978
View this thread: http://www.excelforum.com/showthread...hreadid=557648

Create Headings from Column Data
 

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 dataautofilter and
follow your nose from there.

HTH
Martin