Convert array data to excel format

Shell Programming and Scripting
1

I need your help in changing the script
I have data has below text file

 
:> cat my_emp
Employee array(0)
Name :  Albert
No : 1234
Address: stationstraat
City: Utrecht
Employee array (1)
Name : Kouwen
No : 1256
Address: stationstraat
City: Amsterdam
Employee array (2)
Name : Peter
No : 9256
Address: atomweg
City: Groningen
Employee array (10)
Name : Claudio
No : 9257
Address: Beatrixlaan
City: DenHaag

I wanted to convert that as below:
Desired output:

 
Name  | No| City
Alber |1234| Utrecht
Kouwen|1256| Amsterdam
Peter|9256| Groningen
Claudio|9257| DenHaag

I used the script below:

 
awk -F"= " '/Name/{if(s){print s}s=$NF}
/No/ || /City/{s=s "\t" $NF}
END{print s}' my_emp

my out put is not as expected but as here:
Actual output:

 
Name :  Albert  No : 1234       City: Utrecht
Name : Kouwen   No : 1256       City: Amsterdam
Name : Peter    No : 9256       City: Groningen
Name : Claudio  No : 9257       City: DenHaag

I am strugling to modify the script to ge my desired output,
any expert can help please?
Regards,

2

Something like this?

awk '
/^Name/{n=$NF}
/^No/{n=n "|" $NF}
/^City/{print n "|" $NF}
' file
3

FS is set to "= ", but that is not what is used in the input file.