Results 1 to 3 of 3

Thread: Deduping Values in Large Dataset - 7K rows X 30 columns

  1. #1

    Deduping Values in Large Dataset - 7K rows X 30 columns



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

    Deduping Values in Large Dataset - 7K rows X 30 columns

    1. spreadsheet column A is 7K rows and all unique values
    2. columns associated with each row contain values
    3. some of the column values are duplicates of other columns
    4. need to remove duplicates in each row leaving only 1 (screenshot below - wouldnt let me post screenshot)


    The top of the screenshot is what it looks like now.

    The lower table is what I need it to look like.

    Can anyone guide me on how to achieve this?
    Attached Files Attached Files

  2. #2
    Acolyte Jean Paul's Avatar
    Join Date
    May 2015
    Posts
    22
    Articles
    0
    Excel Version
    2013
    this macro remove all duplicate of the row
    Attached Files Attached Files

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    onespeed, this is a cross post (you have posted the same query elsewhere) without including links to where you have done so.
    Please have a careful read of http://www.excelguru.ca/content.php?184 to understand why this important, then make the necessary additions of links to all sites/threads.
    Ultimately, onespeed, it will be to your benefit.

    To others, I would prefer if people considering responding to this thread would delay doing so until onespeed has complied.

Posting Permissions

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