I have a form that is formatted very similarly to the example below. When the data from my form is submitted, the second table is given as extra columns instead of as a row.
Using that example, let's say I am buying 1 Appple at .59 ech, 2 Oranges at .24 each, and 3 bottles of Saint-Emillion for 7.99 each.
Ideally when I submit the data I would have an XML table that is readably by Excel as something like this:
Instead, when I open the XML file in Excel I get a table that looks like this. It lumps the Fruit data in columns to the right of the Wine columns.
How would I go about rectifying this?
Retrieving data ...