I am dealing with a set of Excel 2002 worksheets organized in a standard
format in which each row represents a record for a single day and there are
numerous variables recorded in columns. I need to transpose this to a format
in which there is a single row for each non-zero occurence of each variable
on each day, and the row needs to keep the date as its first-column entry.

To illustrate, I need to change this:
date1 v1 v2 v3 v4
date2 v1 v2 v3 v4...

to this:
date1 v1
date1 v2
date1 v3
date1 v4
date2 v1
date2 v2...

This seems like a perfect task for a macro, but my macro literacy is
insufficient to figure it out. Any suggestions geared toward a non-VBASIC
-speaker would be greatly appreciated. Thanks in advance for any tips you
can send my way.