I am attempting to load a list hierarchy through an import file (example below).
I have close to 800 locations so as you can imagine manually structuring the hierarchy isnt an option :). I have tried setting up the headers and in the Grid View and assiging parents of each column header, but the location names dont automatically go into a hierarchical list.
Does anyone know how I can get the list hierarchy to show up automatically when I import the entire file so it looks like below...
-----United Kingdom Location
... View more