Converting a list of people with addresses to one address per row?

Hi everyone!
I need to convert a list of addresses, first and last names so that one unique address appears per row, while the names populate the columns behind.
For example, I have:



What I aim to get is:



I've tried using this: https://exceljet.net/formula/multi-criteria-lookup-and-transpose
{=INDEX(rng1,MATCH(1,($A1=rng2)*(B$1=rng3),0))}
But I'm working with hundreds of thousands of people and addresses, so this one just hangs and the data refreshes really slowly, only when I scroll down. This approach also includes a lot of manual work, since I don't have multiple criteria, just one, so I need to create COUNTIFs for each address, which slows the process even more.
I'm wondering if there is any faster or more streamlined process to accomplish this?
I'm using MS Office 2019 Excel Version.
Let me know if I can provide any further information.
Thanks in advance!

Attach a workbook with some data in it.

Ahh, lack of response from the OP due to problem being solved elsewhere…

cross posted without links:
How can I convert a list of addresses, first and last names so that one unique address appears per row, while the names populate the columns behind? : excel
https://www.reddit.com/r/excel/comments/l2oam5/how_can_i_convert_a_list_of_addresses_first_and/
How can I convert a list of addresses, first and last names so that one unique address appears per row, while the names populate the columns behind? | MrExcel Message Board
https://www.mrexcel.com/board/threa...he-names-populate-the-columns-behind.1159274/

Olat/olat_dragneel, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184