Shell Programming and Scripting

Date,Status,orig,dest,in,out,when,where
2012-01-01 00:30:37,I,48,56,23,98,83,34
2012-06-17 15:00:38,I,72,43,12,65,34,12

2012-01-01 00:30:37,I,orig,48
2012-01-01 00:30:37,I,dest,56
2012-01-01 00:30:37,I,in,23,
2012-01-01 00:30:37,I,out,98
2012-01-01 00:30:37,I,when,83
2012-01-01 00:30:37,I,where,34
2012-06-17 15:00:38,I,orig,72
2012-06-17 15:00:38,I,dest,43
2012-06-17 15:00:38,I,in,12
2012-06-17 15:00:38,I,out,65
2012-06-17 15:00:38,I,when,34
2012-06-17 15:00:38,I,where,12

$ awk -F"," 'NR==1 { for(L=3; L<=NF; L++) O[L]=$L; next } { for(N=3; N<L; N++) print $1, $2, O[N], $N }' OFS="," data

2012-01-01 00:30:37,I,orig,48
2012-01-01 00:30:37,I,dest,56
2012-01-01 00:30:37,I,in,23
2012-01-01 00:30:37,I,out,98
2012-01-01 00:30:37,I,when,83
2012-01-01 00:30:37,I,where,34
2012-06-17 15:00:38,I,orig,72
2012-06-17 15:00:38,I,dest,43
2012-06-17 15:00:38,I,in,12
2012-06-17 15:00:38,I,out,65
2012-06-17 15:00:38,I,when,34
2012-06-17 15:00:38,I,where,12

$

awk -F, 'FNR==1{split($0,h,FS);next}{for(i=3;i<=NF;i++) print $1,$2, h[i],$i}' OFS=, myFile

awk -F, '
# for first line/header (FNR==1), split the record/line ($0) by FieldSeparator (FS)
# and put the result into an array 'h' index-ed by field numbers - go the next record/line (next)
FNR==1{split($0,h,FS);next}
# other records/lines
{
# iterate through the fields of the current record/line starting at the 3-rd position
# output/print the first 2 fields followed by the corresponding field in array h (h[i]) AND
# the value of the iterated field ($i)
for(i=3;i<=NF;i++) 
   print $1,$2, h[i],$i
}' OFS=, myFile