Expand my Community achievements bar.

XML fields importing in separate rows in Excel

Avatar

Level 1

When importing the *.xml files from a returned form into Excel 2010, the fields correctly populate into columns, but each field also gets a separate row. It seems the xml is specifying a 'new row' for each field, when it isn't required. This creates a diagonal display of information (headers along row 1, info in A2, B3, C4, D5...)

When I import multiple *.xml, i get multiple diagonal displays, which look pretty, but aren't very functional.

Any ideas on how to get this to display correctly?

Thanks

0 Replies