+ Reply to Thread
Results 1 to 2 of 2

split column into two columns while copying to new sheet (and preserve sort order)

  1. #1
    Registered User
    Join Date
    04-08-2013
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    2

    split column into two columns while copying to new sheet (and preserve sort order)

    i have one long column of data that is sorted alphabetically. i would like to take that column and copy it to a second sheet, and whilst copying, i need to split the single column into two columns, but keep the sort. to further complicate things, though, i need the split to work such that the sort breaks up properly across specified page breaks.

    something like this:

    A
    A
    A
    A
    B
    B
    B
    B
    C
    C
    C
    C
    D
    D
    D
    D
    E
    E
    E
    E
    F
    F
    F
    F
    G
    G
    G
    G
    H
    H
    H
    H

    would become

    A C
    A C
    A C
    A C
    B D
    B D
    B D
    B D
    (page 1 break)

    E G
    E G
    E G
    E G
    F H
    F H
    F H
    F H
    (page 2 break)

    i'm surely missing something very simple here, but i can't get it to work. i'm fine with the sorting and copying, but when trying to make the split from one column into two (and keep the sort across page breaks), things always go awry. any and all help would be greatly appreciated!

  2. #2
    Registered User
    Join Date
    04-08-2013
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: split column into two columns while copying to new sheet (and preserve sort order)

    yikes, i don't know where my head was when i typed my original post, but the parameters of this project are slightly more complex.

    i actually have TWO columns that i need to split across FOUR columns. in my control/data sheet, column A is sorted alphabetical ascending, and column B is an integer (which is tied to the sorting in column A). i want to do as i described above and split these two columns into four columns on a new sheet across specified page breaks, but i don't want to lose the alphabetical sort when doing so.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1