How to pivot data in the DataRefiner?
Description
We will see how easy it is to transpose data in the DataRefiner.
For this I will start from this dataset:
Â
in which as you can see it shows the data in columnar format with one column per year,
and I want to pass to this format that is more suitable when it comes to representing data or storing the data:
Once the data is loaded
I'll select the Country Name column and select Transpose> Transpose cells across columns into rows:
We will find a window like this one, in which I will select that I want to move from column 2005 to column 2009 to a new column and do the Fill down:
With this I will have obtained this:
Now we only have to separate the year column into 2 columns, one for the year and one for the value, for that I select the column and do Edit column> Split into several columns:
I change the separator for:
And I will get
Where I only have to change the names of the columns:
Â