Dynamic column generated from two tables

I have two tables. Table A has a different person and Table B has its travel history.
I want to generate a view where multiple visits of a person can appear as a column.