My client wants to view a table with a hierarchy (Region-> Sub-Region -> Country).
But they all come in a single column, "Country".
Please find attached sample data.
My question would be, what is the best approach to create the hierarchy while/after loading the data? And how should I create the table in desired format (with proper spacing, parent->child like Nordics-> Norway)?