I have asked everyone I know how to fix this and need to know ASAP if there is a way to fix it or not. Because you are all geniuses, I come to you.
I have created a PDF form in Adobe LiveCycle and have added a submit button to give me the XML code to import into Excel. When I open it, I get three options: Open as an XML table, as a read-only workbook, or use the XML Source task pane.
I have been through all options and the XML table is the one that looks the best to me. The only problem is that in every column, the data is pushed down one row from the previous column. My data looks like steps and I don't want that. I need all the information from the form to be in one row.
If you'd like to see a screen shot, please contact me. I really could use some help on this. Thanks!