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!
Bookmarks