Is there a way to combine form data from two or more columns in Google Spreadsheet?

  • venkivivek
    Asked on April 21, 2017 at 2:07 PM

    Hi,

     

    I got interested in your product and started using it today. It is user-friendly and I am loving it.

    In regards to form output, I am trying to integrate with Google spreadsheet. My concern is that I have fields of the same kind multiple times, for multiple entries, is there a way I would be able to get them all under the same column in the spreadsheet. I searched the internet for an answer to this question and found none. I know this is not something related to your support but any help is greatly appreciated. If I can get this function to work, I can convince my team to get an upgraded version of jotforms 

     

    Screenshot:

    Is there a way to combine form data from two or more columns in Google Spreadsheet? Image 1 Screenshot 20

     

    Best Regards,

    Vivek Sampath

    Jotform Thread 1125674 Screenshot
  • Welvin Support Team Lead
    Replied on April 21, 2017 at 5:03 PM

    Each field will have own its column in the Google Spreadsheet file. If you want to combine two or more columns into one, you need to do it inside Google Spreadsheet manually. Here are some guides from Google Forums that would help you merge columns:

    https://productforums.google.com/forum/#!topic/docs/-4zQnClH8lk

    https://sites.google.com/a/slu.edu/tips/home/combiningandsplittingdatainspreadsheets

    Let us know if you need further assistance.