Results 1 to 3 of 3

Thread: Help with data

  1. 02-22-2011, 07:02 AM #1
    scauk
    scauk is offline Registered User
    Join Date
    Feb 2011
    Posts
    2

    Help with data

    I hope you can help. I have a massive list of data which I want to organise.

    The data is separated into product SKU and DESCRIPTION.

    The list will often list the product SKU and then that SKU may have up to 10 different DESCRIPTIONS. What I want is to end up with a list of unique SKU’s and one merged description of all the DESCRIPTION. Some SKU’s may only have one description some may have up to 10. I have tried a number of things with no luck.

    I have about 22,000 lines representing around 4000 unique SKU’s
    What I have:

    SKU DESCRIPTION
    1A3d Black hat
    2d44 Red hat
    1A3d large headgear
    1A3d dark coloured
    2d44 rojo
    3dss Blue hat

    What I want:

    SKU DESCRIPTION
    1A3d Black hat large headgear dark coloured
    2d44 Red hat rojo
    3dss Blue hat

    Happy to do it in access or excel. Really sorry if this is not the right forum but I have been trying for days and it has left me stuck

    Thanks,

    SCAUK
    Reply With Quote Reply With Quote
  2. 02-22-2011, 08:20 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Where are those data now?
    Reply With Quote Reply With Quote
  3. 02-22-2011, 08:31 AM #3
    scauk
    scauk is offline Registered User
    Join Date
    Feb 2011
    Posts
    2
    They are in a CSV file which I have put into excel. Column A is Sku Column B is Description
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules