Having a result appear for one field only

[MariaT]

So to explain this:
 

I have mock data of people including demographies and used date of births. 
 

I created a search and report database however I want there to be only one result for the individuals demographies and the rest of the results be used date of births by individual how would I achieve this?

I have attached an example of what I'm wanting to achieve and for reference the first circled section would be the demographies I want to show and the second circled section would be the additional date of births used.

[telly]

Hi @MariaT,

You can create a unique ID for that specific record, for more information about the table structure you can check this link: https://www.caspio.com/blog/data-normalization/

 

[MariaT]

@telly I've looked into unique ids and distinct records but I don't think they're able to assist me in accomplishing this.