Cells to columns in OpenRefine

Question

I've got a dataset in CSV that I want to convert to JSON. Before conversion, I need to reformat the data to get the proper multidimensional structure. The data contains the results of the last election in Sweden, and it is divided by county ("Kommun"). There are 291 counties, and 9 parties. I want:

• One row per county,
• One column for each party, with each row displaying each party's results.

This would result in 10 columns (county + parties) and 291 rows (1 per county).

How do I achieve this using Open Refine/Google Refine? My current data is shown in the image below.

Answer 1

Transpose -> Columnize by key/value should do the trick.