Unanswered: Convert Existing Table to a new Table with a new layout
I am trying to write an SQL query that takes one table and its data, rearrages it into a new fomat and creates a new table with the newly rearranged data. Below is the example of what I currently have and what I want to make it look like. Please ignore the extra " ---- ", I did this to try and keep the spacing so it would be easier to read.
It's been a while for me writing SQL statements and I am a little rusty. I have done this in the past but I just can't figure it out now, so if anyone has an answer for me I would greatly appriciate it.