CODEWITHSUNDEEP
pivot-tabletransposeopenrefine
user14469578
user14469578

Reputation: 21

Transposing columns as rows and rows as columns in OpenRefine

Simple newbie problem to tranpose cells and rows but can't figure it out: I downloaded WDI data where the years are in columns and the countries and indicators are rows (image 1). I know how to transpose the years as rows (image 2), but how can I also send the indicators as colums so it looks like the third image?

Many thanks!

image 1

image 2

image 3

Upvotes: 0

Views: 181

Answers (1)

Antoine Beaubien
Antoine Beaubien

Reputation: 126

If you have this:

enter image description here

Choose « Columnize by key/value columns... » in the Transpose menu item of the column menu.

enter image description here

Choose the two columns, one for the column names and the other for the values.

enter image description here

And you should get this…

enter image description here

Don't forget to vote if you like my answer.

Regards, Antoine

Upvotes: 1

Related Questions