Alright, so this is my second time ever asking a question on stackoverflow, and this one I believe is a little complex. If you need any extra information let me know and I will provide it, and thanks for all replies/answers!
Basically I want to take this existing table with columns as follows:
Day | Open | Closed | Dealer
Monday 0:00 9:00
Tuesday 0:00 14:00
Sunday 0:00 12:00
One method uses
select Dealer, 'Monday' as dow, Mopen as "open", Mclosed as "closed" from t union all select Dealer, 'Tuesday' as dow, Tuopen as "open", Tuclosed as "closed" from t union all . . .
Creating another table depends on the dialect of SQL. Often
create table newTable as works.