For your scenario, I would first **[create a selection view](https://community.denodo.com/docs/html/browse/8.0/en//vdp/administration/creating_derived_views/creating_selection_views/creating_selection_views#creating-selection-views)** on top of this existing view. Then, I would create a new field called **'pivot'** and use the **[pivotregister](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20XtraFuncs%20-%20User%20Manual#h.fcztfxfhg97q)** function like
> pivotregister(<created_array_name>, 'Region: type, Country: type, Company: type, Subdivision: type')
where the **type** value is the datatype of the corresponding fields.
This function creates a field called 'pivot' with an array of 4 columns such as **Region, Country, Company and Subdivision**.
Then, I would create another selection view on top of this view and in the **Output** tab, Right-click on the 'pivot' field and select **'Project subfields of 'pivot''**.
This will project the fields in the array into individual columns.
If you still need assistance and if you are a user with valid support access then you can create a support case in **[Denodo Support Site](https://support.denodo.com/)** so that our support team will assist you further.
Hope this helps!