- NDPrepAsked on October 01, 2013 at 02:26 PM
I am trying to edit the excel file to separate out the payment product field so I can organize what people are purchasing, but I when I seperate it I would like it to each field to go to the same column. We have multiple options for purchase, so when the columns seperate I want all the "Total Number of Attendees" in column AA and "Sponsor a Teacher" in column BB, etc. How can I do that?
- JotForm SupportjonathanAnswered on October 01, 2013 at 04:17 PM
When you said "multiple options", you meant multiple payment forms. From what I can see on the form on this page http://www.notredamepreparatory.org/culinaryfest/registration.asp , it has two payment options (2 forms)
And what you wanted to achieve is to combine the Total Number of Attendees option (Quantity) in the payment field of the 2 forms into a single column in an Excel sheet.
This is doable by using the Excel text to column function to separate the payment field options of each form (as was described here), and then, combine the "Number of Attendees" column into a single column on separate sheet using Excel export range or vlookup function.
BUT please confirm to us first if my understanding is correct and if this is what you wanted to do, so we can proceed and make sample and instructions of it.
I will await for your updated response.
- NDPrepAnswered on October 01, 2013 at 04:24 PMSorry for the confusion. I meant multiple items in the payment field. I am fine that the payment options going into two excel files, but in each one the payment fields combine all payment items. So just looking at the check payment option, the excel file has all payment products in one field. In researching I don't see a way to stop that from happening, but when organizing the event we need to know who bought what. We followed the directions to separate them out, but that doesn't separate in the same column - it just places it in the next column. I need all attendees to go to one, then all teacher sponsors in another, etc. so when I scroll through who attended I can pull out the people who purchased raffle tickets from those who didn't.
Sent from my iPad
- JotForm SupportjonathanAnswered on October 01, 2013 at 04:48 PM
If I am correct this time, you only want to achieve the separate column for each payment items. What you wanted was separate column for each of the payment items as described exactly on this thread .
By default, the downloaded Excel file of the form payment submissions have all the payment items combine into a single column like this screen
but I know, that you know this already (so you wanted to separate this first) -- Can you tell us if you have successfully separated each item into a separate column using the text to column function?
Once you have separated this to a column, meaning you are able to extract the items separately, you can easily transpose a row to a separate column again using transpose (here is an Excel guide)
Please update us.