I am using the forumla below to prevent my graphs from dropping to
'zero' where data is not yet available over the course of weeks in a
quarter. In the past, the data has been spread across columns in a
single row. Now I have the reverse (data is within a column) and of
course, the formula doesn't retreive the data that I want. Since I'm
not clear on the underlying logic, can someone recommend a way to
'flip' the results I am getting? Thanks.

=OFFSET(Retrieve!$J$17,,,,COUNT(Retrieve!$J$17:$J$ 29))