use warnings;
use strict;
my $table1 = <
) {
chomp;
my ($id, $value) = split;
next if $id eq 'ID';
$values{$id}[$tableIndex] = $value;
}
++$tableIndex;
}
for my $id (sort keys %values) {
print "$id";
print ' ', $values{$id}[$_] || 0 for 0 .. $tableIndex - 1;
print "\n";
}
####
Aa 22 34 0 66
Bb 28 0 75 0
Cc 32 112 91 94
Dd 50 77 132 0
Ee 0 89 0 213
Gg 0 0 0 250
Kk 0 124 0 0