Data Shaping in Google Refine by AJ Hirst.
From the post:
One of the things I’ve kept stumbling over in Google Refine is how to use it to reshape a data set, so I had a little play last week and worked out a couple of new (to me) recipes.
The first relates to reshaping data by creating new rows based on columns. For example, suppose we have a data set that has rows relating to Olympics events, and columns relating to Medals, with cell entries detailing the country that won each medal type:
A bit practical but I was in a conversation earlier today about re-shaping a topic map so “practical” things are on my mind.
With the amount of poorly structured data on the web, you will find this useful.
I first saw this at: Dzone.