---
title: "How to pivot data in the DataRefiner?"
canonical: "https://onesaitplatform.refined.site/space/DOCT/2220794536/How%20to%20pivot%20data%20in%20the%20DataRefiner%3F"
format: markdown
---
### 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](https://gist.githubusercontent.com/tkb/6136793/raw/af3aee9bf34d269c2c3c7672cd69a3910f80c9d0/lifeexpectancy-pivoted.csv)

 

![image](media://c3f893de-f218-4abb-9093-ab394eeb29b7)

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:

![image](media://c3a1fe65-185a-4f4a-b2ff-5d206beb5f83)

Once the data is loaded

![image](media://12350654-9a47-49e0-896e-a0dbca3452e7)

I'll select the **Country Name** column and select **Transpose> Transpose** cells across columns into rows:

![image](media://d218c4cf-d7c2-4ee8-bc13-d1a17628e3bc)

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:

![image](media://143a5c89-637d-453e-9d2e-72987b1ff499)

With this I will have obtained this:

![image](media://17e642a6-3b90-40a6-aef1-8b9023b489b6)

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:

![image](media://ed7139a1-2740-4eeb-b81d-48ca874c7230)

And I will get

![image](media://a729a312-ab9b-4741-a316-8038e3f8c334)

Where I only have to change the names of the columns:

![image](media://c3a11602-5271-4efc-b4a7-5be8c74e8c8c)