+ Reply to Thread
Results 1 to 3 of 3

ebay bulk combining duplicates and cleaning / sorting data prior to mail merge

  1. #1
    Registered User
    Join Date
    01-02-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Angry ebay bulk combining duplicates and cleaning / sorting data prior to mail merge

    Hi everyone,
    I am selling on ebay however I am spending much too much time on the excel sheet which I download 2/3 times a week from ebay bulk site.
    Some of the tasks I have managed to automate but some I am unable to do on my own. I can see on this forum that it can be done however my knowledge of vb is too limited to implement.
    Please find attached the before and after.

    The main task I am struggling with when the buyer buys 2 or more items
    I want to combine the rows with duplicate data,
    combining data from 'N' in column 'N' xxx+xxx+xxx
    add up the values to the total price in 'U'
    and then delete the redundant rows.

    Problem

    (buyer) user id N U
    ur_z_rzruzr 3rRzz crc v cu u cx1 £2.50
    ur_z_rzruzr 15uuzRT Wcu £2.50
    czcucttcc10 1xrutt £2.99
    czcucttcc10 rVttRcx cX £6.50

    Result

    (buyer) user id N U
    ur_z_rzruzr 3rRzz crc v cu u cx1+15uuzRT Wcu £5.00
    czcucttcc10 1xrutt+rVttRcx cX £9.49


    Thank you for your help

    attached before / after

    jumbledSalesHistory.xls
    jumbledSalesHistorysolved.xls

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: ebay bulk combining duplicates and cleaning / sorting data prior to mail merge

    You can add Pivot table:

    Delet row between header name and the data (2nd row)
    Select all -> Insert -> Pivot data

    and choose User Id and Sum of Total price (I also add count of user Id)
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-02-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: ebay bulk combining duplicates and cleaning / sorting data prior to mail merge

    Hi thank you !
    this adds up the totals for each customer which is my 2nd task
    my first task is to combine the items in column 'n' xxx+xxx+xxx
    I need this as it gets printed onto the mailmerge sticker so thet the packers know what to pack.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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