hi i have following table columns and i want to convert these all columns into row
SELECT [CASHINHAND] ,[CASHATBANK] ,[DEPOSITS] ,[ACCRECEVABLE] ,[SUNDRYDEBTORS] ,[LOANANDADVANCES] ,[CURRENTASSETS] ,[FIXEDASSETS] ,[INVESTMENTS] ,[CLOSINGSTOCK] ,[ACCPAYABLE] ,[SUNDRYCREDITORS] ,[BANKLOANS] ,[DUTIESANDTAXES] ,[PROVISIONS] ,[STAFF] ,[CURRENTLIABILITIES] FROM [BalanceSheet]
required output looks like
CASHINHAND 118950
CASHATBANK 200
DEPOSITS 3000
ACCRECEIVABLE 25000