R
Ray S.
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.
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.