I need help about a SQL query that blow my mind. I need to use SQL to get a XML format

Initial result
| Code article | Test code |Test specification|Measure method|
| ——– | ————– |——————|————–|
| 0211315V3 | CORA_S3_CR |Contenance ras bord S3 Critique|QOI-I-005|

Wanted result
| Code article | Value |Column|
| ——– | ————– |——————|
| 0211315V3 | CORA_S3_CR |Test code|
| 0211315V3 | Contenance ras bord S3 Critique |Test specification|
| 0211315V3 | QOI-I-005 |Measure method|

Can someone help me about this please ?

Thanks in advance