Merge column headers and transpose

Shell Programming and Scripting
1

Hello Everyone!
I am new on this forum and this is my first post. I wish to apologize for my, not canonical, English.
I would like to solve this problem but I have no clue of how do it!I will be grateful if someone could help me!
I have a table like this:

gene TF1 TF2 TF3 TF4
gene1 1 2 3 4
gene2 1 1 4 4
gene3 1 2 3 3
gene4 1 2 3 4
gene5 1 2 1 3
gene6 2 2 1 2
gene7 3 3 1 3
gene8 2 3 1 4

Each row is a gene and each column a transcription factor.The number in the intersection means if the TF there is, there is not, is upregulated, is downregulated.
Now what I would like to obtain is something like that:

gene TF
gene1TF1 1
gene1TF2 2
gene1TF3 3
gene1TF4 4
gene2TF1 1
gene2TF2 1
gene2TF3 4
gene2TF4 4
and so on

Adding at each gene the TF and the relative number!I get crazy!
I really hope that someone could help me!
Thanks a lot

Giuliano

2 
awk '
NR==1 {
  n=split($0,h,FS)
  print $1, "TF"
  next
}
{
  for(i=2;i<=n;i++)
    print $1 h, $i
}' myFile
3

Thaks a lot but in the output the gene is not repeated for each trasnscription factor(TF).Its shown just the first TFfor each gene!!
Other suggestion?

4 
awk '
 NR==1 {   n=split($0,h,FS)   print $1, "TF"   next } 
{   for(i=2;i<=n;i++)     print $1 h, $i }' myFile

and with myFile:

gene TF1 TF2 TF3 TF4
gene1 1 2 3 4
gene2 1 1 4 4
gene3 1 2 3 3
gene4 1 2 3 4
gene5 1 2 1 3
gene6 2 2 1 2
gene7 3 3 1 3
gene8 2 3 1 4

produces the following:

gene TS
gene1TF1 1
gene1TF2 2
gene1TF3 3
gene1TF4 4
gene2TF1 1
gene2TF2 1
gene2TF3 4
gene2TF4 4
gene3TF1 1
gene3TF2 2
gene3TF3 3
gene3TF4 3
gene4TF1 1
gene4TF2 2
gene4TF3 3
gene4TF4 4
gene5TF1 1
gene5TF2 2
gene5TF3 1
gene5TF4 3
gene6TF1 2
gene6TF2 2
gene6TF3 1
gene6TF4 2
gene7TF1 3
gene7TF2 3
gene7TF3 1
gene7TF4 3
gene8TF1 2
gene8TF2 3
gene8TF3 1
gene8TF4 4

this matches exactly your desired output.

5

Also Try..

awk 'NR==1{split($0,P);print $1,substr($2,1,2)}
    NR>1{for(i=2;i<=NF;i++){print $1""P,$i}}' file
6

Ok it works.I made I mistake!!
Thanks a lot!!