Results 1 to 3 of 3

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

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte Olat's Avatar
    Join Date
    Jan 2021
    Posts
    1
    Articles
    0
    Excel Version
    2019

    Question 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:

    Click image for larger version. 

Name:	Screenshot_1.jpg 
Views:	6 
Size:	9.9 KB 
ID:	10287

    What I aim to get is:

    Click image for larger version. 

Name:	Screenshot_2.jpg 
Views:	8 
Size:	8.3 KB 
ID:	10288

    I've tried using this: https://exceljet.net/formula/multi-c...-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!
    Last edited by Olat; 2021-01-22 at 02:10 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •