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:

https://gist.githubusercontent.com/tkb/6136793/raw/af3aee9bf34d269c2c3c7672cd69a3910f80c9d0/lifeexpectancy-pivoted.csv

 

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:

Â