I have some Excel files with elements and attributes all of different values.
I would like to have Elements and attributes as column headings. Where attributes are used as headings the element name should proceed the attribute name with an _ separating them.
The value of the element should have the element name followed by the word "value in the header as in AdminStatus_Value in the example below.
AKA" languageId="505062" organizationNameLocalNorma
should have as headings: