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

Question

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?

Answer 1

Yes it is possible and it is called a UNPIVOT

For your case:

SELECT period, value, category
FROM 
   (SELECT VendorID, charcge,nocharge
   FROM Table) p
UNPIVOT
   (value FOR category IN 
      (charge,nocharge)
)AS unpvt;