Grouping and transposing data in excel

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:

spreeadsheet 1

In a separate sheet I need to rearrange such data in the following way:

spreadsheet 2

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.


    More Information: