You can convert daily data to weekly data in Excel by creating a pivot table, and grouping the rows in the pivot table in groups of seven days, or one week.

Semi-structured data is here to stay, and it offers the potential for business advantage to companies that know what to do with it. Mark Whitehorn has advice on how to do that.