What you have there is exactly (or extremely close to) what I originally coded; however, after considering the OP's "writing these values to excel", I quickly changed that to a Schwartzian Transform.

You're quite correct about not knowing what the OP really wanted. With any of the suggested solutions, questions regarding how an undef is written to a spreadsheet remain outstanding (and this would almost certainly require further coding).