My solution to this misery has been to glue another row of pin headers directly outside the mis-spaced ones, leaving one pin blank and connecting the offset pins "diagonally", somewhat like this:
oooooooo*oooooooo
\\\\ ||||||||
oooooooo.oooooooo
What a neat solution!