0

I have a google form to collect - Family Group Name and Family member details.

I get the whole data in one row. enter image description here

Is there a way to get the data saved in the format in the image through some add in etc.. ? say mapping Family member name to a specific column on the google sheet, sex to a sex column in the sheet...

Improve this question
3
  • Question posts on this site should contain only one question otherwise they could be considered too broad and closed.
    – Rubén - Volunteer Moderator - ♦
    Commented Feb 21, 2018 at 13:09
  • 2
    FWIW I don't think this question is too broad, it is only asking a single question: how to group similar data from a form entry that exists as a single row. I do think you'd need a bit of Apps Script help here to iterate over the row data, and then map names, ages, etc. and write them to a new sheet or range.
    – OnenOnlyWalter
    Commented Feb 22, 2018 at 1:39
  • 1
    can there potentially be any number of people. and are there always only three fields for each person?
    – Aurielle Perlmann
    Commented Feb 23, 2018 at 5:30

1 Answer 1

Reset to default
1 
={OFFSET($A$2,ROUNDDOWN((ROW(A1)-1)/4),0),OFFSET($B$2,ROUNDDOWN((ROW(A1)-1)/4),MOD(ROW(A1)-1,4)*3,1,3)}

Dragfill down.

Assumed that:

  • There will only be 3 columns (Name,age,sex) per entry.
  • There will be a maximum of 4 family members per household.
Improve this answer
1
  • Sorry I am semi technical and i get the error - "there is aproblem with this formula.
    – Venkat Peddireddy
    Commented Feb 28, 2018 at 23:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.