Hi folks,
I have a simple website export of category names which are parent & childs of each other. They all reside in column "A". In column "B" & "C" I have the Category ID & Parent ID which is effectively a parent Category ID.
"0" is the "Default Category" or master root if you like and what I'm trying to achieve in a column next to A,B,C is to produce a path mapping of the parent/child relationship(s). A few examples below:
The default master category (0) = Default Category
1st level category = Default Category/Widgets
Child of 1st level category = Default Category/Widgets/Widget Accessories
and so on and so forth...
I basically have no idea how to achieve this. I did look at the LOOKUP function, VLOOKUP, MATCH & INDEX but I think neither achieve what I want. I'm sure there is an easier way I'm just being really noobish so I'm wondering whether any of you clever folks have any idea!? Here's a link to the excel file if anyone is interested in looking at it;
http://dl.dropbox.com/u/5988259/Specialists Group/Data/categories.xlsx
Any feedback greatly appreciated. Cheers, Sasdaman
I have a simple website export of category names which are parent & childs of each other. They all reside in column "A". In column "B" & "C" I have the Category ID & Parent ID which is effectively a parent Category ID.
"0" is the "Default Category" or master root if you like and what I'm trying to achieve in a column next to A,B,C is to produce a path mapping of the parent/child relationship(s). A few examples below:
The default master category (0) = Default Category
1st level category = Default Category/Widgets
Child of 1st level category = Default Category/Widgets/Widget Accessories
and so on and so forth...
I basically have no idea how to achieve this. I did look at the LOOKUP function, VLOOKUP, MATCH & INDEX but I think neither achieve what I want. I'm sure there is an easier way I'm just being really noobish so I'm wondering whether any of you clever folks have any idea!? Here's a link to the excel file if anyone is interested in looking at it;
http://dl.dropbox.com/u/5988259/Specialists Group/Data/categories.xlsx
Any feedback greatly appreciated. Cheers, Sasdaman