+ Reply to Thread
Results 1 to 5 of 5

Splitting a column with a 1000 entries into multiple columns

  1. 03-27-2010, 11:10 PM #1
    Coaster
    Coaster is offline
    Forum Contributor
    Join Date
    10-11-2008
    Location
    Portugal
    MS-Off Ver
    Excel 2010
    Posts
    111

    Splitting a column with a 1000 entries into multiple columns

    Hi,

    I want to split a column which has a lot of data into several columns, 24 entries at a time.

    Is this possible?
    Last edited by Coaster; 03-28-2010 at 10:58 AM.
    Reply With QuoteRegister To Reply
  2. 03-27-2010, 11:13 PM #2
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Splitting a column with a 1000 entries into multiple columns

    Coaster, could you provide a few dozen rows of sample data and manually create the desired results? I'm not sure I can picture what you're after

    cheers
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
  3. 03-27-2010, 11:21 PM #3
    Coaster
    Coaster is offline
    Forum Contributor
    Join Date
    10-11-2008
    Location
    Portugal
    MS-Off Ver
    Excel 2010
    Posts
    111

    Re: Splitting a column with a 1000 entries into multiple columns

    Hi teylyn,

    Sorry I wasn't clear. I want to split the data in 'sheet 2' 25 entries at a time, to fill the table in 'sheet 1' appropriately.

    Thank you for your quick reply
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-28-2010, 12:29 AM #4
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Splitting a column with a 1000 entries into multiple columns

    Hi Coaster,

    this in B2 of Folha1:

    =INDEX(Folha2!$B:$B,ROW(A1)+(COLUMN(A1)*25)-25)

    copy down and across
    Reply With QuoteRegister To Reply
  5. 03-28-2010, 10:58 AM #5
    Coaster
    Coaster is offline
    Forum Contributor
    Join Date
    10-11-2008
    Location
    Portugal
    MS-Off Ver
    Excel 2010
    Posts
    111

    Re: Splitting a column with a 1000 entries into multiple columns

    tks a lot!
    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)

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