By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | FirstName | MiddleName | LastName |
|---|---|---|---|
| 1 | Fred | A. | Smith |
| 2 | Anna | null | Polack |
| Result |
|---|
| <Answer name="ID_1"><value>1</value></Answer><Answer name="FirstName_1"><value>Fred</value></Answer><Answer name="MiddleName_1"><value>A.</value></Answer><Answer name="LastName_1"><value>Smith</value></Answer><Answer name="ID_2"><value>2</value></Answer><Answer name="FirstName_2"><value>Anna</value></Answer><Answer name="LastName_2"><value>Polack</value></Answer> |