General

Re: Export Sharepoint InfoPath Data To Excel Fields As Rows

Patrick Halstead — Sun, 22 May 2016 22:21:29 GMT

Hi again, InfoPathY:

Sorry to hear you have not reached InfoPath enlightenment.

We are here to help.

The issue may be that you have choice sections, but I am not sure about your "Pivot Table" comment. Are you exporting to Excel? If so, you'll want to make sure that you have one repeating section or table (not seven).

How about paying us for an hour of one-on-one help? If you aren't satisfied, we'll refund your money. Just go to qdabra dot com and click on Support -> Pay as you go.

Cheers,

Re: Export Sharepoint InfoPath Data To Excel Fields As Rows

infopathy — Fri, 20 May 2016 21:19:32 GMT

Hello Patrick, I tried your solution without success. Export continues as columns. Cannot make rows in pivot table resulting in laddered rows and so unworkable. I have seven sections or choice sections. Each of these contains several questions. I have tried question column and answer column. I even tried drop-downs with answer and question in each selection as well without success. As well tried exporting then transposing and that failed too. Problem is that questions/comments are of varied length and make for long, ungainly headings. That's why I thought would work better as rows. Thanks Infopathy

Re: Export Sharepoint InfoPath Data To Excel Fields As Rows

Patrick Halstead — Tue, 17 May 2016 00:45:30 GMT

Hi InfoPathY and thank you for posting,

You'll want to use a repeating table or section and default values for your questions.

Add a repeating table with two columns. One column is your question text and the other column is your answer value.

Go to Data->Default Values and add rows for all of the questions and type in the question text in the question text field. Make sure you don't click OK until you or done because it will close the dialog that you must use to enter all of them. :)

Then, when you export to Excel, choose the option to export a table.

Hope that helps! :)

Export Sharepoint InfoPath Data To Excel Fields As Rows

infopathy — Fri, 13 May 2016 15:42:03 GMT

I have created a form with many questions. For each question have corresponding answer field, drop down, Yes, No, NA. When export to Excel questions are headers, unfortunately, some questions are long making for unwieldy column headers. Would like question to be rows, not headers. How can I design form to obtain this layout when export list? Thanks much.