+ Reply to Thread
Results 1 to 3 of 3

Sorting singe row and column data into row and multiple colums

  1. #1
    Registered User
    Join Date
    09-23-2006
    Posts
    27

    Sorting singe row and column data into row and multiple colums

    Hi,
    I have product codes that can have several barcodes assigned to it. When I extract these from my system to excel it creates a new row with the barcode next to it, if a product has 3 barcodes it creates 3 rows as shown on the barcode sheet. What I am looking for is a way to sort out the barcodes that have 1 row per product and several columns depending on the amount of barcodes attached to the product, as shown in the barcodeoutput sheet. I have over 10,000 rows in my full list so its not possible to do this manually

    Thanks in advance,
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Sorting singe row and column data into row and multiple colums

    Try the attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-23-2006
    Posts
    27

    Re: Sorting singe row and column data into row and multiple colums

    Thanks for that, works perfectly

+ 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: 2
    Last Post: 06-17-2011, 03:00 PM
  2. Sorting Data From One Column into Multiple Columns
    By Justin Hoffmann in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2006, 11:10 AM
  3. [SOLVED] Sorting Data Colums
    By Jez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2006, 05:35 PM
  4. How to add a singe symbol to the whole column data?
    By usmleboy in forum Excel General
    Replies: 3
    Last Post: 01-07-2006, 04:10 AM
  5. How can you identify duplicate entries in a singe column?
    By Melissa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2006, 05:25 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