Thread
:
Sort data into order of product
View Single Post
#
2
February 21st, 2006, 02:56 PM posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: n/a
Sort data into order of product
Again. Post in ONE group only
--
Don Guillett
SalesAid Software
"Jackmac" wrote in message
...
Hi there,
I've got a list of products for my company but it is listed in product
group, the products for that group coming underneath.. like this:
MT-AUDIO-MOUNTS:
Vogels VRS045 VCR/DVD support in black
Vogels VRS045 VCR/DVD support in silver
Vogels VRS045 VCR/DVD support in white
MT-SPEAKER-WALL:
Vogels VLB100 tilting speaker wall mount in black
Vogels VLB1015 center speaker wall mount in silver
Vogels VLB1025 speaker wall mount in silver
Vogels VLB200 speaker wall mount in black
Vogels VLB50 speaker wall mount in black
Vogels VLB50 speaker wall mount in silver
Vogels VLB50 speaker wall mount in white
MT-SPEAKER-WALL:
Kef 3 x wall brackets for KHT1001
MT-AUDIO-MOUNTS:
B-Tech BT325 disco/PA speaker mount in black
B-Tech BT325K fixing kit for BT325
B-Tech BT325X adaptor for external mount
I want if possible to create a new list which will show the product group
with the products underneath..like this
MT-AUDIO-MOUNTS:
B-Tech BT325 disco/PA speaker mount in black
B-Tech BT325K fixing kit for BT325
B-Tech BT325X adaptor for external mount
Vogels VRS045 VCR/DVD support in black
Vogels VRS045 VCR/DVD support in silver
Vogels VRS045 VCR/DVD support in white
MT-SPEAKER-WALL:
Kef 3 x wall brackets for KHT1001
Vogels VLB100 tilting speaker wall mount in black
Vogels VLB1015 center speaker wall mount in silver
Vogels VLB1025 speaker wall mount in silver
Vogels VLB200 speaker wall mount in black
Vogels VLB50 speaker wall mount in black
Vogels VLB50 speaker wall mount in silver
Vogels VLB50 speaker wall mount in white
Anybody got any ideas?
TIA...Jack
Don Guillett
View message headers