is it possible create a sql view from "horizontal" to "vertical"

is it possible create a sql view from "horizontal" to "vertical"

please see my attached below: my actual data will be store in table 1, can
I create a view that display data like table 2?