First, I apologize if I'm posting this in the wrong place, but I think it's right!
I've used LiveCycle Designer ES2 to create a fairly basic form. It's a table with some dropdown lists for auditing charts at multiple worksites. There are a total of 8 columns and 15 rows. There will be multiple sites each with their own file, so I want to merge the files into a .csv using Acrobat Professional X. The problem I'm encountering is when I fill out a few rows of the form and try export it into a .csv using Acrobat Pro X it puts the whole file into one row (it doesn't export the same way the table is formatted). I'm thinking I need to somehow setup the columns in the table or create LiveCycle before I use Acrobat X to merge the completed files, but I'm not familiar enough with LiveCycle to do this.
If anyone has any feedback on this I'd really appreciate it!
That is what I would expect. Each form export is treated as a single row within Excel (albeit a very long row, with many columns). The column headers are named after the absolute reference of all of the objects in the form.
You would need to "process" the spreadsheet to get it into a different format. Maybe a pivot table (???).