#!/usr/bin/env perl use strict; use warnings; use Data::Table; my $t = Data::Table::fromCSV('data.txt', 0, undef,{delimiter => ' '}); my $mt = $t->melt(['col1', 'col2']); my $ct = $mt->cast(['col1', 'col2'], 'variable', Data::Table::STRING, 'value', \&col_join); $ct->sort('col1', 1, 0); print $ct->csv(0, {delimiter => " "}); exit; sub col_join { my @data = @_; my $joined = join(":", @data); return($joined); }