i'm trying to create an excel spreadsheet to be used to perform some basic "planning".
In one sheet I have a list of couples:
In a separate sheet I need to rearrange such data in the following way:
So basically I need to group the items by week number and transpose the items associated with each week number horizontally.
Does anyone know if this is feasible with excel?
A Pivot Table will quickly handle that job.