Need An Efficient Way To Repeat The Column Headers Of A Table

There are 2 tables
tPeople

ID Name

1 Arun
2 B
3 C

tAddress

PeopleID Address
1 Test Address A
1 Test Address B
1 Test Address C
2 Address A
3 Address1
3 Address2

Expected Result

ID Name Address1 Address2 Address3

1 Arun TestAdressA Test Address B Test Address C


2 B Address A

3 C Address1 Address2

Address columns repeated = max(count(Address)) for PeopleID

Help me on this!

I can do it through dynamic sql using Execute sp_executesql

Is there any workaround except this?