I am getting a 4 part extract from an enterprise tool which come out in XML, that was irritating but I can work around that, but whats weird is that when I import the data into excel the fields are moving around (see screen shot). No one can seem to either explain to me why this is happening or fix it so I guess I am stuck with the problem.
My question is (drum roll) is there a way to normalizse the fields so that "Landscape_name" always goes to column A and "Landscape_handle" always goes to column B for example? I have highlighted the fields below which seem to be in motion. My assumption is that if I were to pull this extract again diffrent fields would move around which is why I would like to "fix" their position if possible
<colgroup><col style="width: 136pt; mso-width-source: userset; mso-width-alt: 6619;" span="4" width="181"> <tbody>
</tbody>
My question is (drum roll) is there a way to normalizse the fields so that "Landscape_name" always goes to column A and "Landscape_handle" always goes to column B for example? I have highlighted the fields below which seem to be in motion. My assumption is that if I were to pull this extract again diffrent fields would move around which is why I would like to "fix" their position if possible
| landscape_name | landscape_name | landscape_name | landscape_name |
| landscape_handle | landscape_handle | landscape_handle | landscape_handle |
| name | name | name | name |
| model_type | model_type | model_type | model_type |
| model_handle | model_handle | model_handle | model_handle |
| Network_Address | Network_Address | Network_Address | Network_Address |
| Security_String | Security_String | Security_String | Security_String |
| Value_When_Orange | Value_When_Orange | Value_When_Orange | Value_When_Orange |
| Value_When_Yellow | Value_When_Yellow | Value_When_Yellow | Value_When_Yellow |
| subnet_mask | subnet_mask | subnet_mask | subnet_mask |
| Value_When_Red | Value_When_Red | Value_When_Red | Value_When_Red |
| network_address2 | network_address2 | network_address2 | network_address2 |
| name3 | name3 | name3 | name3 |
| model_type4 | model_type4 | model_type4 | model_type4 |
| model_handle5 | model_handle5 | model_handle5 | model_handle5 |
| sysUpTime | TopologyModelNameString | sysUpTime | sysUpTime |
| USER_AssetOwner | sysUpTime | community_string | USER_AssetOwner |
| community_string | USER_AssetOwner | TopologyModelNameString | community_string |
| TopologyModelNameString | community_string | USER_AssetOwner | TopologyModelNameString |
| sysLocation | sysLocation | sysLocation | sysLocation |
<colgroup><col style="width: 136pt; mso-width-source: userset; mso-width-alt: 6619;" span="4" width="181"> <tbody>
</tbody>
