Change col to row using shell script..Very Complex

Shell Programming and Scripting
1

Hi guys

I have file A with Below Data

ABC123	X1  X2  X3 
ABC123	Y1 Y33 Y4
ABC123	Z1 ZS2 ZL3
ABC234	P1 PP3 PP9
ABC234	Q1
ABC234	R1 P09 PO332 PO331 OKI12  
..
..
..

Now I want file B as below

ABC123	X1 X2 X3;Y1 Y33 Y4;Z1 ZS2 ZL3
ABC234	P1 PP3 PP9;Q1;R1 P09 PO332 PO331 OKI12

Thanks in Advance

2 
awk '{t=$1;$1="";a[t]=a[t]$0";"}END{for(i in a)print i,a}' infile | sed 's/;$//'
1 Like