Results 1 to 4 of 4

How to automate, convert single column of data into two columns of data?

Threaded View

Dale Saukerson How to automate, convert... 06-06-2012, 09:18 PM
NickyC Re: How to automate, convert... 06-06-2012, 11:33 PM
Leith Ross Re: How to automate, convert... 06-07-2012, 02:13 AM
Dale Saukerson Re: How to automate, convert... 06-07-2012, 09:53 PM
  1. #1
    Registered User
    Join Date
    01-15-2012
    Location
    Minneapolis
    MS-Off Ver
    Excel 2013 Win 10 enterprise
    Posts
    10

    How to automate, convert single column of data into two columns of data?

    Customer provides an Excel file that contains 1000s of keycodes in a single column.
    The keycodes are not sequential. They are 16 alpha numerica characters with hyphens every four characters.
    It's just a long list of keycodes.
    I convert this into a text file for feeding an industrial disc (CD) printer. This is easy.
    The printer spits discs one at a time, onto spindles that hold 100 discs, rotate for empty spindle, till it runs out of keycodes.

    I also print the customer's file onto paper.
    I massage the file to print in two columns of 50 codes each.
    I use this report to spot check the output of the disc printer against the customer's file.
    The report is exactly 100 codes per page.
    I check the first and last (100th) disc of each spindle.

    I cut and paste from client file into my file and adjust page breaks to get 100 codes per page.
    I also add two columns so I can add a numbering sequence for the codes.
    This is laborious when done by hand.

    How can I best automate this process?

    Two attachments are examples of what I do.
    Attached Files Attached Files
    Last edited by Dale Saukerson; 06-07-2012 at 08:41 PM.

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