Filtering and reporting data with 12 month grid

[adweaver]

I have a list of products I'm promoting.

Format is as follows

Item Name/Item No/Price/Discount/Jan/Feb/March/April/.../Dec

Some products are on discount in multiple months, so the monthly columns are filled with 'X' to signify that they're on deal that month,

I'd like to be able to run a report for each month.

Everything I look at to sort monthly data assumes there's a column named month, and each entry can only be associated with ONE month. Can't figure out for the life of me how to run a report on each monthly column.

Any ideas?

 

[smkyle]

What information would you like in the report? Could you give an example of what you would like the result to be? Are you using a pivot table?