Results 1 to 3 of 3

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

  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?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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:	5 
Size:	9.9 KB 
ID:	10287

    What I aim to get is:

    Click image for larger version. 

Name:	Screenshot_2.jpg 
Views:	7 
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 03:10 PM.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,890
    Articles
    0
    Excel Version
    365
    Attach a workbook with some data in it.

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,890
    Articles
    0
    Excel Version
    365
    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/comme...ses_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/thread...ehind.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

Posting Permissions

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