OT: a problem about text manipulation

[Paul Smith]

On 10/31/06, Paul Smith <phhs80 at gmail.com> wrote:
> > > I am looking for an automatic way of transforming my text file into
> > > another one with the format
> > You may try this:
> >   cat ./test.txt | awk '{print $1" "$2; print $1" "$3; print $1" "$4}' | grep
> > -v ' $'
>
> Thanks for all suggestions.
>
> Yakov: can your solution be adapted to the conversion from
>
>
> 1       E               E       E
> 2       C               D
> 6
> 3       B               E               D
> 4       C               E               D
> 5               D               E
>
> to
>
> 1       E
> 1       E
> 1       E
> 2       C
> 2       D
> 6
> 3       B
> 3       E
> 3       D
> 4       C
> 4       E
> 4       D
> 5       D
> 5       E
>
> ?

Please, notice that there is no letter associated to the number 6.

Paul