Results 1 to 3 of 3

Sorting singe row and column data into row and multiple colums

Threaded View

dhbyrne Sorting singe row and column... 04-23-2014, 12:46 PM
AB33 Re: Sorting singe row and... 04-23-2014, 01:41 PM
dhbyrne Re: Sorting singe row and... 04-24-2014, 04:56 AM
  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

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. [SOLVED] 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. 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. [SOLVED] 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