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.
Example:
https://acrobat.com/app.html#d=4Nj*BeqL1iG-6tfQBLoIfA
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:
| Item | Quantity | Price | Amount |
|---|
| Apples | 1 | .59 | .59 |
| Oranges | 2 | .49 | .48 |
| Saint-Emillion | 3 | 7.99 | 23.97 |
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.
| ns1:dataNode | ns1:dataNode2 | ns1:dataNode3 | subTotal | ns1:dataNode4 | Total | item | quantity | price | amount | item5 | quantity6 | price7 | amount8 |
| dataGroup | dataGroup | dataGroup | 23.97 | dataGroup | 25.04 | 1 | 1 | 0.59 | 0.59 | 1 | 3 | 7.99 | 23.97 |
| dataGroup | dataGroup | dataGroup | 23.97 | dataGroup | 25.04 | 2 | 2 | 0.24 | 0.48 | 1 | 3 | 7.99 | 23.97 |
How would I go about rectifying this?
