Hi,
I think in order to get the data so that it works with the system. You need to know what the end format of the Excel sheet should look like.
The example of the file you posted has rows of data.
How would one determine as you put it "Parent/Child" relation.
If we can understand the format then we may be able to create a code for it.
I'm thinking you only want data in 2 columns.
Column A has the "Parent category" and column B has the "Sub category".
|