If you can want to have two columns, you should be able to create this table with two header rows using a pivot table.
In the script add a PersonNum field to your Persons table to say whether will appear in column 1, 2 ... n.
On the pivot chart:
First dimension = PlaceName
Second dimension = PersonNum (the column identifier)
First expression = only(PersonName)
Second expresison = only(Age)
You could then drag and drop dimension 3 (PersonNum) onto horizontal header to show person-1 or person-2 etc. columns.
There are different ways to do this.
I would prefer to seperate the personnumber into a new field
In other word create data like this:
Place Name Age PersonNumber beach toto 25 Person1 street jane 32 Person1 beach tarzan 32 Person2 office mike 42 Person1 street john 50 Person2 office
I attached an example of one way to do this.
Is this what you are looking for?