Using awk to transpose column to row

Question

I have an input data file: ``` anim gent FZ543 1 FZ543 2 FZ543 3 FZ543 1 FZ547 4 FZ547 3 FZ547 3 FZ547 1 ``` I wanted to transpose these data to:- ``` anim gent FZ543 1 2 3 1 FZ547 4 3 3 1 ``` In other words, I wanted to transpose elements from vertical to horizontal. I can used AWK Comand Thanks for your atention.

Accepted Answer

```
awk 'NR==1{print} NR>1{a[$1]=a[$1]" "$2}END{for (i in a){print i " " a[i]}}' file
```

OUTPUT

```
anim   gent
FZ543  1 2 3 1
FZ547  4 3 3 1
```

Using awk to transpose column to row

Solution

Problem