from two dimensions to one

I'm sure that this question is frequent. I wasn't sure how to define it well enough to do the search.

Concept: The concept is basic. How do we gather information in a two-dimensional table and put it into a single line of data?

Context: We are a residential design firm. We have a database with all of our clients and their data in it. We want to send a survey to our clients asking them about the people and pets in their home and we want multiple pieces of information about each such as DOB, name, and gender. The logical way to approach this is to set up a report with rows and columns, which would work if we wanted to set up a separate table for every client, which we do not. Is there a way to make this happen?