Crosstab to List table using awk Function

Shell Programming and Scripting
1

What I am trying to achieve is turning crosstab into a normal table

e.g.
convert following table

Jan	Feb	Mar	Apr	May	Jun

Australia 1 2 3 4 5 6
USA 7 8 9 10 11 12
China 13 14 15 16 17 18

to

Australia Jan 1
Australia Feb 2
Australia Mar 3
Australia Apr 4
Australia May 5
Australia Jun 6
USA Jan 7
USA Feb 8
USA Mar 9
USA Apr 10
USA May 11
USA Jun 12
China Jan 13
China Feb 14
China Mar 15
China Apr 16
China May 17
China Jun 18
I have been trying to come up with following awk code, but not quite getting the expected result.

awk '
BEGIN {FS = "\t" ;}
{
for ( NR >1 && x=2 ; x<=NF ; x++)
{
for (NR == 1 && a=3 ; a<=NF ; a++)
{
M[a]=$a
}
BC = $1
print BC , M[x], $x
}
}
' filename

If anybody tells a better way of doing it, I would greatly appreciate it.

Thank You !!

2

How about this:

awk '
NR==1{
	for(i=1;i<=NF;i++)
		head=$i
}

NR>1{
	for(i=2;i<=NF;i++)
		print $1,head[i-1],$i
}' yourFile
3

It worked
Thanks a lot !!