I have a master list that i need to separate out into sevral lists based on there values (see example)

Additionally, I would like that the redistributed lists contain the values and discriptions from the master list and be listed on consective lines.

List A
Kitchen 5000
Toilet 300
Taps 100
Lights 400
Carpets 2300
Tiles 1600
Doors 900


List b List c List d
< $300 $300 - $1200 Above $1200
Toilet 300 Lights 400 Kitchen 5000
Taps 100 Doors 900 Carpets 2300
Tiles 1600

Cheers
John