+ Reply to Thread
Results 1 to 3 of 3

Remove duplicates and change format

  1. #1
    Registered User
    Join Date
    09-17-2020
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    12

    Remove duplicates and change format

    Hello,

    I currently have an Excel sheet which contains the data of order numbers, account name, service, productname (orderitem) and price per orderitem.
    Is there a way to change the data and format to remove the order number duplicates and spread out the order line items (and price) over different columns in a fast way?

    Please see attached Excel document for an example. In the first tab 'Current format' you can see how it's currently existing in the datasheet.
    On the second tab 'Req. format' you can find an example of how I would like the document/ data to be.

    Manual adjusting wouldn't be practical, since the original document contains thousands of records.
    (Btw, I don't even know if it's possible to make a quick solution for this. If this isn't possible you can tell me as well and I will try to find a different solution instead).

    Thanks in advance!

    ~ Niels
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,079

    Re: Remove duplicates and change format

    You have posted in the Outlook section - was this in error and would you like the thread moved to another section?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    09-17-2020
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    12

    Re: Remove duplicates and change format

    Quote Originally Posted by AliGW View Post
    You have posted in the Outlook section - was this in error and would you like the thread moved to another section?
    Created new one in correct section. You can close this one.
    Last edited by NielsvB; 11-26-2020 at 10:21 AM.

+ 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. Replies: 6
    Last Post: 11-27-2018, 07:17 AM
  2. Compare lists of URLs for duplicates, and remove duplicates
    By mrfranklin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-13-2018, 05:27 AM
  3. [SOLVED] Remove duplicates and change dates - VBA
    By wrightyrx7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2014, 11:50 AM
  4. Replies: 12
    Last Post: 09-10-2013, 09:45 PM
  5. Replies: 8
    Last Post: 12-17-2012, 05:30 AM
  6. Remove brackets without format change
    By Oleg in forum Excel General
    Replies: 5
    Last Post: 01-19-2009, 09:42 AM
  7. [SOLVED] Remove Data Format Change
    By ACFalcon in forum Excel General
    Replies: 3
    Last Post: 11-17-2005, 02:45 PM

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