It sounds like you need a union join, but I don't believe a published data source can do that yet.
You will likely need to export the data from the published data source into the same excel file (different sheet).
Have you tried appending the data? Are all the fields the same?
Hi Cor Bader . What you mean with appending the data? So far i created a scaffold datasource with all the category/weeks combinations and managed to partially get this to work but creating another issues (that deserves another topic).