Multiple rows that share the same key, but have multiple criteria move to one row only.

Any help would be appreciated. I'm an excel beginner and would love some feedback. Thank you.

Example of how my results currently display :

Col A Col B Col C Col D
123 John Smith Home 999
123 John Smith Auto 998
223 Sara Miller Home 825
223 Sara Miller Auto 824
223 Sara Miller Farm 823
424 Steve Bee Home 727
324 Jill John Home 543
324 Jill John Auto 542
324 Jill John Farm 541


Goal of how I want my results to display:
Col A Col B Col C Col D Col E Col F Col G Col H
123 John Smith Home 999 Auto 998
223 Sara Miller Home 825 Auto 824 Farm 823
424 Steve Bee Home 727
324 Jill John Home 543 Auto 542 Farm 541

I think I need a formula that moves my data that if there is more than one same record for Col A and Col B, then the data for the second same or greater records moves from Col C and Col D to Col E, Col F, Col G, Col H, etc...

hmm..... I'm in over my head, but I know there's a better way Thank you.

Thank you Tony. I will give this a go, much appreciated for your time Have a great weekend.