I'm sorry I confused you.
Please look at the output again! You will see two sets of output. The 1st set only contains

Code:

NAME<tab>FREQUENCY

exactly as you requested, but the output data matches your sample input instead of your sample output. And the output provided by my script prints entries in the ouput in the order they were found in the input file. (Your sample output seemed to be in a fairly random order and had FREQUENCY values for some NAMEs that were not present in your sample input.)

You said you had a second awk program that would give you a merged list of all frequencies associated with a NAME. The second part of the output produced by my awk script did that without needing a second script.

Looking at my script again:

Code:

awk '   
{       for(i = 1; i < NF; i++) {
                printf("%s\t%s\n", $i, $NF)
                ($i in a) ? a[$i] = a[$i] " " $NF : a[$i] = "\t" $NF
        }
}
END {   print ""
        for(i in a) print i a[i]
}' file

If you don't want the 2nd part of the output, remove the code shown in red. That will leave you with:

Code:

awk '{for(i = 1; i < NF; i++) printf("%s\t%s\n", $i, $NF)}' file

which prints a line for each field except the last from every input line in the file. Each output line will contain the name found in one of the 1st (NF - 1) fields ($i) from a line in the file and the frequency found in the last field ($NF) separated by a tab character.

The stuff that was in red created an array (a[]) where the array index was a NAME and the valie of a[NAME] is a list of the frequencies found in the input. The END clause in the awk script printed an empty line to separate the two parts of the output followed by the elements of the array giving the NAME and the list of frequencies found for that NAME in a random output order. (The frequencies for a given NAME in the output appear in the order in which the entries were found in the input file.)

Please let me know if this still is not clear.