Changing Excel Spreadsheet Format

[oa6n]

Hi,

I have a spreadsheet that lists item numbers in column A (going down). Columns B through Z has an offer (in text ) associated with each item number. The headings for each text is a date. I would like to convert the data so that I have the dates going down in column A then the item number for each date that it shows up in Column B and then the text associated with that specific date and item number in column C. Is there an easy way to do this?

I hope this makes sense.

Thanks,

 

[venkat1926]

please give a small extract of about 5 rows of data.