+ Reply to Thread
Results 1 to 3 of 3

Splitting 2000 rows of data into multiple columns

  1. #1
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sefton
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    158

    Splitting 2000 rows of data into multiple columns

    I'm looking to split a large amount of data into separate columns so that it can be further manipulated.
    I have around 2000 rows of data which have been extracted from elsewhere. There's currently only one column for all these rows but each cell contains a lot of information which is very rarely identical in length.

    It's records of phone calls so they're generally laid out as follows;
    Initials "for" initials "(" Equipment + Peripheral 1 + Peripheral 2 ")" "=" 4-6 digit number

    Sometimes a single row may contain 2 or 3 sets of equipment & peripherals information.

    I'm just looking to separate every separate word at the moment and then take it from there.
    Can anyone suggest the quickest method to have everything separated out?

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Splitting 2000 rows of data into multiple columns

    If you really want to keep it manually, then simply highlight your column of text and use the DATA > TEXT TO COLUMNS function using [x] Space as your delimiter.


    Since this is the vba FORUM, we can employ VBA but you would need to provide a sample workbook to work from. WE only need 10-20 sample rows of data, just enough for you to include examples of ALL the variations that need to be covered. In the sample workbook, also mockup a second sheet showing how those 10-20 sample rows would split out.
    Last edited by JBeaucaire; 10-04-2016 at 10:15 AM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sefton
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    158

    Re: Splitting 2000 rows of data into multiple columns

    ah right, sorry. I must have mis-clicked when looking to post a new thread. Thanks for the help.

+ 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: 14
    Last Post: 08-20-2014, 05:46 AM
  2. Splitting rows with multiple columns into seperate rows for time points.
    By mbracha in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-16-2013, 10:06 AM
  3. Splitting a list of data into multiple columns
    By ozge in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 06:17 PM
  4. Splitting a row of multiple columns into multiple rows
    By anguyen816 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2012, 01:30 PM
  5. Splitting a row that has multiple columns into multiple rows..
    By anguyen816 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2012, 12:36 PM
  6. [SOLVED] Excel 2007 : splitting data into multiple columns
    By SubtleFudge in forum Excel General
    Replies: 3
    Last Post: 07-17-2012, 02:21 PM
  7. Splitting cells, rearranging columns and rows, cleaning up data
    By daniel.henriksen in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-11-2010, 03:55 AM

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