Microsoft Business Intelligence (Data Tools): SQL - How can we convert columns to Rows

Microsoft Business Intelligence (Data Tools): SQL - How can we convert columns to Rows: How can we convert columns to Rows in SQL? There are a lot of concepts to store multiple values against a single field to handle the ...