+ Reply to Thread
Results 1 to 2 of 2

Splitting a list of data into multiple columns

  1. #1
    Registered User
    Join Date
    03-18-2015
    Location
    California
    MS-Off Ver
    2007 & 2013
    Posts
    1

    Splitting a list of data into multiple columns

    Hi not to bring this up again sorry but I was wondering how to do this except with 2 columns instead of one? for instance
    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 03-18-2015 at 04:31 PM. Reason: Moved to its own thread. Please read and follow the Forum Rules, link above in the menu bar.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,412

    Re: Splitting a list of data into multiple columns

    Do you always want to split after 3 records, or do you want that to be a variable that you can specify, as in the original thread? If so, which cell will you use to house the variable?

    Also, will your data start in row 1, or are you likely to have headers that you want to reproduce across row 1?

    (So many questions !!)

    Pete

+ 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. Splitting a list of data into multiple columns
    By PeterGriffin in forum Excel General
    Replies: 9
    Last Post: 11-14-2015, 03:50 PM
  2. [SOLVED] Splitting a list of values in separate columns
    By siouxfire in forum Excel General
    Replies: 20
    Last Post: 05-09-2014, 07:42 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 multiple entries in single cell into multiple columns
    By David_Mitchell in forum Excel General
    Replies: 12
    Last Post: 01-24-2013, 06:57 AM
  5. [SOLVED] Excel 2007 : splitting data into multiple columns
    By SubtleFudge in forum Excel General
    Replies: 3
    Last Post: 07-17-2012, 02:21 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