I've got a spreadsheet of various categories and I'd like to create a column which gets the parent name of that particular category.
They are currently broken down as follows:
01.01 Category 1 01.02 Category 1a 01.02.01 Category 1aa 01.02.02 Category 1ab 01.02.03 Category 1ac 01.03 Category 1c
I've put the numbers into a seperate column using
and I've put the names of the categories into another column using
but I've not managed to get the parent name into a column yet so was hoping someone could help.