Registration with Guests

When would like to attach a JotForm to a Google Sheet and one of our forms arranges all the information into sheet columns.

We are searching for a way to for the JotForm to take guest(s) information and create sheet rows instead of columns. We think it has to do with how the form is set up to receive guest information.

Perhaps there's a way to send them to a new form specifically for guests...but then, we wouldn't know what registrant they are coming with.

Any insights/advice would be helpful.

Thank you!

Each submission when exported to a spreadsheet will be entered in its own row.  Each different field is separated into a different column.  Columns are added to the sheet in the order of the fields in the form.

If you wouldn't mind providing a bit more information on how you would like the Guest data exported compared to the primary registrants data, we will see what we can do.