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

  • Profile Image
    venkivivek
    Asked on April 21, 2017 at 02: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:

     

    Best Regards,

    Vivek Sampath

  • Profile Image
    Welvin
    Answered on April 21, 2017 at 05: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.