I am working with an excel file that has the same week across multiple rows.
The ask is to find an average for each week.
How can the data be organized to show one average for each week?
It should be fine across multiple rows. Just use the week dimension and set your measure aggregation to AVG. Tableau doesn't care if there's multiple records for the same week.
Retrieving data ...