How to convert rows into columns in SQL Server & explain with an example?(Interview Question)

Answer 1

Yes

Answer 2

You can convert rows in to Columns in SQL Server by using "PIVOT Operator"

Answer 3

I'm not an expert but I'm also not sure why you would want to do this - do you mean turning each row of a table into a column instead, like this?

Header: animal | name | age
Row 1: cat | kit | 3

into:

Header: cat
Row 1: kit
row 2: 3