+ Reply to Thread
Results 1 to 4 of 4

Please help Combine Lists and Flatten Data

  1. #1
    Registered User
    Join Date
    11-16-2015
    Location
    Baltimore MD
    MS-Off Ver
    365
    Posts
    28

    Please help Combine Lists and Flatten Data

    I am trying to combine a new list with an existing data set. Many of the items on the list are alias' for the same account. I will be importing data from different sources that will continue to use these names/alias'. I need to create a Master List where the Parent name does not duplicate and can be used as a lookup table in Power BI. On the workbook attached is an example of an Existing Master and the New accounts to add.

    Also, is there a way to highlight Accounts in the same column that are very similar but not exact? Acura Nissan, Acura Toyota, The Acura Nissan

    Please let me know if you need more information. Any help of direction is appreciated. Thank you.
    Attached Files Attached Files
    Last edited by Baltimorejack68; 10-18-2019 at 05:28 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,421

    Re: Please help Combine Lists and Flatten Data

    As to producing a list where the Parent name does not duplicate try:
    For the parent names:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    For the aliases:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    11-16-2015
    Location
    Baltimore MD
    MS-Off Ver
    365
    Posts
    28

    Re: Please help Combine Lists and Flatten Data

    Thank you for your help. I think this will work. I'll apply it to the larger data sets and see how it goes. I appreciate the help.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,421

    Re: Please help Combine Lists and Flatten Data

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Flatten an array of data into 1 row
    By sotplugy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-12-2019, 08:30 AM
  2. Combine 2 lists about the same data
    By ryangodammit in forum Excel General
    Replies: 2
    Last Post: 03-22-2019, 02:19 PM
  3. Transpose or flatten out cell data
    By Bryan Karsten in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2017, 12:02 PM
  4. [SOLVED] How to compare and combine data from new and old product lists?
    By jms1989 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-21-2014, 08:55 AM
  5. [SOLVED] Attempting to flatten multiple temporal data points for single identifier
    By cranialnerve in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-22-2013, 01:36 AM
  6. Flatten Data Script
    By JimmyA in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-15-2011, 12:08 PM
  7. Please Help Combine to Two Lists
    By lostinformulas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-31-2006, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1