Search Results

A minor tweak to radoulov's solution which fixes the 4th column:
awk 'p {
n = split(p, t)
if (t[n] == $NF)
print t[1], t[3], $2, ++i"I", t[5]
else
i=0
}
{ p = $0 }
' infile

Untested:

awk 'p {
n = split(p, t)
if (t[n] == $NF)
print t[1], t[3], $2, t[4], t[5]
}
{ p = $0 }
' infile

awk '{
n11 = split($11, t11, ",")
n12 = split($12, t12, ",")
for (i = 0; ++i < n11 - 1;) {
s12 = $2 + t12[i]
print $1, s12 + t11[i], $2 + t12[i + 1], i "_" $4
}
}' infile