Table into 3 column data

[Nimish]

I have a schedule spreadsheet set up like this with times as the data
elements under each day.

AS OF MONDAY 10/9/2006 APPROVED: John McTigue

NAME POS MON TUE WED THUR FRI SAT SUN ID


I want to create a macro that will export the following to a csv file:

ID, Date(Mon), Start
ID, Date(Tue), Start
ID, Date(Wed), Start
ID2, Date(Mon), Start

Anyone have a way to help?