I need a TSQL to achieve a requirement near to pivot

I have table data like

Now, I want a result like this,

Keep in mind, I want only 3 columns, IsHeader, Col1, Col2 and a query must be dynamic.

Please help.