I have a script and I want to make a user interface using ExcelVBA, in such
a way that it will be possible to load the input (input_v39) and to press a
button which will automatically give me the output (output_v39_transpose), is
this possible? please do not hesitate to send me a demo if you
have. Here is my script

#!/bin/sh
# the file input_v39 is transposed using the follwing procedure in order to
get all #channel names on lines instead of in columns

gawk '

BEGIN { OFS= " "}

{ for ( i = 1; i <= NF; i++ ) {
a[i,NR] = $i
}
m = NF
n = NR
}
END {
for ( j = 1; j <= m; j++ ) {
for ( k = 1; k <= n; k++ ) {
printf( "%s ", a[j,k] )
}
print
}
}

' input_v39| sort|uniq > output_v39_transpose