If you're using SQL Server, you're looking for UNPIVOT:

select Location, Type, Date, Account, Value
from t unpivot (Value for Account in (Quantity, Net)) av;

See it running on some of your data.