Shell Programming and Scripting

awk ' NR == 1 { next }
{
 name[NR-1] = $2
 value[NR-1] = $3
}
END {
 while ( ++n < NR - 1 ) printf "%s ", name[n]
 print ""
 while ( ++v < NR - 1 ) printf "%s ", value[v]
 print ""
}' "$FILE"

awk -v NamesList="customerCode,PrimaryAddress,Model_Handle,usid" \
'
 
function output_datas(    i, out) {
   if (Valid) {
      for (i=1; i<=NamesCount; i++) {
         out = (out ? out OFS : "") Values[i];
      }
      print out;
   }
}
 
function reset_datas(    i) {
   Valid = "";
   for (i=1; i<=NamesCount; i++)
      Values[i] = "";
}
 
BEGIN {
   NamesCount = split(NamesList, Names, ",");
   Header = "";
   for (i=1; i<=NamesCount; i++) {
      Indexes[tolower(Names[i])] = i;
      Header = (Header ? Header OFS : "") Names[i];
   }
   print Header;
}
 
/^Id/ {
   output_datas();
   reset_datas();
   next;
}
 
{
   name = tolower($2);
   value = $3;
   if (name in Indexes)  {
      Values[Indexes[name]] = value;
      Valid++;
   }
}
 
END {
   output_datas();
}
' mogarb.dat

Id Name Iid Value
0x4440001 customerCode 44077
0x11d2a PrimaryAddress 57.217.41.201
0x129fa Model_Handle 0x11322800
0x4440000 usid fi00bxtaa4
0x4440008 customerName Zurich
Id Name Iid Value
0x4440001 customerCode 44044
0x11d2a PrimaryAddress 57.210.40.20
0x129fa Model_Handle 0x11326500
0x4440000 usid fi00bxtbb0
0x4440008 customerName Zurich

customerCode PrimaryAddress Model_Handle usid
44077 57.217.41.201 0x11322800 fi00bxtaa4
44044 57.210.40.20 0x11326500 fi00bxtbb0

awk 'BEGIN { 
  print "customerCode PrimaryAddress Model_Handle usid" 
  }
c && c < 5 { 
  v = v ? v FS $NF : $NF 
  } 
++c == 6 { 
  print v
  v = c = "" 
  }' filename