I have added an Excel sheet to help clarify my request. Note that I an trying import multiple xml files to a single Excel worksheet. Not all the xml files will contain the same fields as the Master Schema. So I need to ensure the xml files with fewer column will adjust appropriately to the Master Schema.
Hope someone can nudge me along.