excelgroupingtranspose

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?


Solution

  • A Pivot Table will quickly handle that job.

    img


    More Information: