+ Reply to Thread
Results 1 to 6 of 6

Parsing a horizontal dataset into a ssingle vertical column

  1. 10-07-2016, 09:30 AM #1
    niggzso
    niggzso is offline
    Registered User
    Join Date
    03-14-2007
    Posts
    14

    Parsing a horizontal dataset into a ssingle vertical column

    I am looking to parse this dataset of UPC Codes (mainly14char ) vertically into 1 column in serial order

    Product #
    10012354000220 29311218003468 10012354105628
    10012894855212 10012354105628
    10012354087658 10012354104515
    10012354087825
    10012354087825
    10012354089997 10012354105574 19300770043602
    10012354087825
    1.93008E+13
    10012354087696 19300770043602
    10012354087825
    10012354000220 2931133003468
    10012894855212 10012354105628 10012354105574
    100122087658 1001222104515
    10012354087825
    1.00129E+13
    10012354089997 10012354105574 1.00129E+13
    1.00981E+13
    10012354087825
    10012354087696 19300770043602 10012354105574 10012354105574
    1.00124E+13
    1.00981E+13
    Last edited by niggzso; 10-12-2016 at 03:05 PM.
    Reply With QuoteRegister To Reply
  2. 10-07-2016, 05:33 PM #2
    niggzso
    niggzso is offline
    Registered User
    Join Date
    03-14-2007
    Posts
    14

    Re: Parsing a horizontal dataset into a ssingle vertical column

    I am actually trying to change the above into data in one column itself ( see attache file for desired result)

    right now i just have to cut and insert paste ..
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 10-07-2016, 05:54 PM #3
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Parsing a horizontal dataset into a ssingle vertical column

    Run it on active sheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 10-12-2016, 01:23 PM #4
    niggzso
    niggzso is offline
    Registered User
    Join Date
    03-14-2007
    Posts
    14

    Re: Parsing a horizontal dataset into a ssingle vertical column

    Thanks Ab33, this works perfectly, however is there a way to remove the text tags in the code itself and convert all the values to number?
    Reply With QuoteRegister To Reply
  5. 10-12-2016, 01:35 PM #5
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Parsing a horizontal dataset into a ssingle vertical column

    Excel displays up to 15 digits only.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 10-12-2016, 03:02 PM #6
    niggzso
    niggzso is offline
    Registered User
    Join Date
    03-14-2007
    Posts
    14

    Re: Parsing a horizontal dataset into a ssingle vertical column

    Thanks a lot for your help man! it works..
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Converting dataset from vertical to horizontal based on fixed criteria
    By LJH2410 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2014, 10:56 AM
  2. [SOLVED] Vertical chart dataset needs to be converted into pivotable dataset
    By aspak84 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-17-2013, 06:06 PM
  3. [SOLVED] Transpose Horizontal to Vertical with ID Column
    By galaxycoff in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-04-2012, 10:16 PM
  4. Vertical to horizontal one column and underneath
    By vinaynaran in forum Excel General
    Replies: 2
    Last Post: 10-14-2009, 01:02 PM
  5. Trying to reference a horizontal row in a vertical column
    By GeoffCJ in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2007, 03:56 AM
  6. Copy horizontal row to vertical column
    By xcelisgr8 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2007, 01:41 PM
  7. how do set up a chart with vertical and horizontal column heading
    By claireann100 in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 06-26-2006, 08:55 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1