#!/usr/bin/perl use warnings; use strict; use feature qw{ say }; use List::Util qw{ uniq }; my @genes; while (<>) { my ($id, $type, $value) = (split)[ 0, 3, 4 ]; push @genes, [ $id, $type, $value ]; } my @types = sort +uniq(map $_->[1], @genes); say join "\t", 'Gene', @types; for my $gene (@genes) { say join "\t", $gene->[0], map $_ eq $gene->[1] ? $gene->[2] : q(), @types; }