A user-friendly tool to transform large scale administrative data into wide table format using a mapreduce program with a pig latin based script.