Editing format of Google Spreadsheet

  • Profile Image
    MTCFVA
    Asked on February 21, 2017 at 04:00 PM

    Hi

    I'd like to play around with the format of my Google Spreadsheet which records submissions. Is there an area of settings where I can do this. 

     

    In particular I'd like to select which fields from the form/submission come through to the spreadsheet. 

    I'd also like to change the orientation (a la transpose) so that the fields are listed on the vertical axis and each new submission populates a new columns rather than a new row. Is this possible?

    Thanks, 

    James

  • Profile Image
    EltonCris
    Answered on February 21, 2017 at 06:18 PM

    Changing the formatting of the integrated spreadsheet will most likely break the integration. 

    We suggest to create a new tab sheet and do all the formatting of the data on the new sheet by copying the data from the first sheet to the new sheet using data reference formula https://support.google.com/docs/answer/75943?hl=en

    You can create a new sheet in the bottom section of the spreadsheet file.

    Hope this helps!