I have a large array that has names as row headings and week dates as column
headings with hours as the data. It looks like a crosstab query would in
Access. What I want to do is convert it to a list where the names repeat in
one column, the week dates for each name repeat in the second column and the
hourly data fills the third column. Example:

name 1 2 3
nancy 40 38 39

I want

name week hours
nancy 1 40
nancy 2 38
nancy 3 39

Is there an easy way of doing this? My array is really quite large and has
many names.