G
Guest
I have a block of data in three columns A, B, C.
I want to be able to sort all the cell data individual by each cell,
starting at A1 working across to C1, then to A2 to C2, then A3 to C3
continuing downwards, so that when you viewing the data, it reads across the
rows in a continous flow from A-Z like this:
0-9
abc
def
ghi
jkl
mno
pqr
stu
vwx
yz
Can somebody tell me how to do this, I have tried all the ranges offfered by
Excel, but nothing seems to work. All data is formatted to Text.
Thank you,
Sue
I want to be able to sort all the cell data individual by each cell,
starting at A1 working across to C1, then to A2 to C2, then A3 to C3
continuing downwards, so that when you viewing the data, it reads across the
rows in a continous flow from A-Z like this:
0-9
abc
def
ghi
jkl
mno
pqr
stu
vwx
yz
Can somebody tell me how to do this, I have tried all the ranges offfered by
Excel, but nothing seems to work. All data is formatted to Text.
Thank you,
Sue