gistfile1.rb

require 'set'
file = File.new("data")

storage = Hash.new {}

file.each_line do |line|
  date, key, value = line.split(';')
  storage[date][key] = value
end

colunms = []
table = Hash.new []
storage.each do |date, hash|
  hash.each do |key, value|
    columns.push(key) unless columns.include? key
    num = columns.index(key)    
    table[date][num] = value
  end
  table[date].map!{|v| v == nil ? 1 : v }
end

print "date"
columns.each { |val|
    print ";" + val
}
print "\n"

table.each {|date, array|
  print "#{date};#{array.join(';')}\n"
}