convert xml with repeating elemets to SQL table

i have an xml with many rows that i want to convert to a sql table. the xml has repeating elements and i want to retrieve the data so every row in the table will have all the column names (all field names in a row ) and their values .

at the moment i can only get the values to appear in one column.

• i have searched the web but could not find something that workd

here is my XML

1

1

0

2

0

0