Single column against multiple rows

Hi, I need to analyze the pre and post data for a sales promotion. The promotion codes are in a single column and appear against each product represented in a single row with a corresponding date. As...