Transpose Weekday Columns to Rows

[gsrai31]

I have a table with 8 columns titled - Destination, Mon, Tues, Wed …to.. Sun. This is shown as "OriginalTable" worksheet in the attached example workbook. I want to create a new table from this original table that looks like "NewlTable" worksheet in the attached example. So I will have a new table that has 3 columns titled - Destination, Day, Weight. Weekdays will become rows so each destination will have 7 rows, one for each day of the week. The measure will be listed against each day of the week. Can someone please look at the attached example for me and help me with this.

Many thanks in advance.

 

[neileg]

I would create 7 queries, one for each day of the week and then union them together. Each would look something like this:

Select Destination, [Mon] AS Weight, "Mon" AS DayOfWeek;

 

[gsrai31]

OK, thanks for your help.