Maybe this, similar to Dalglish instructions:

Make a copy of the data
Choose F5 Special blanks
press [=] followed by [Up Arrow] then [Enter]
Select all data and copy and paste values
Delete any rows you don't want to show

"whatzzup" wrote:

Good afternoon all, i am struggling to create a spreadsheet looking like this
below, this is an hierarchical dropdown, i know its not simple.

Product Type Desc extra
Clothes
Dress
Pants
Long
Regular
Short
Loose
Skirt
Pleated
Causual
Mini
Party
Sweater
Longsleeves
Black
Short sleeves
Red
Blue
Vegetable
Lettuce
x
y
I would appreciate this very much i have been looking at the Dalglish
template and cant seem to be able to match this.
Very much appreciated....