Help with table data

Hello,
I have a huge table of data which the columns are dates and the rows are farms.
I would like to sum the data and to turn it into new table which the columns are weekday and the rows are week number.
How can i do it?
Thanks