* * *Help with Sorting with Merged Cells* * *

[largeselection]

Hello

I was wondering if it would be possible to sort a worksheet by merged cells. Here's an example of the problem:

In colunn A
I have a vertically merged cell (3 cells)
Then I have three lines next to it.

A1
A2
A3

Its like this example, except I only have one A since I have merged the three together. So how can I sort by column A. I would need the three lines next to each merged box to travel with the merged box.

So if I have

B4
B5
B6
A1
A2
A3 (again, A and B are merged into one box)

I would want it to sort to be
A1
A2
A3
B4
B5
B6

So that 4,5,6 stay with B and 1,2,3 stay with A and all move together.

Any help would be appreciated.

 

[Diablo II]

First why Merged cells? the sort need the cell to be the same size. for all that is being sorted, just make your cell a biger to hold your date in one cell. on A. then sort should work for you.

 

[largeselection]

I had it as a merged cell so that it was easier to read.

So that we could see

"A" and then 3 rows next to "A" were all part of the "A" heading rather than having

"A"-Row of info
"A"-Another Row of info
"A"-Another row of info

I tried unmerging the cells so that I had
1-Info
1-Info
1-Info
2-Data
2-Data
2-Data
.
.
.
10-Stuff
10-Stuff
10-Stuff

and then sorted by first column ascending and it sorted but it gave me

1-Info
1-Info
1-Info
10-Stuff
10-Stuff
10-Stuff
2-Data
2-Data
2-Data

Any ideas on why it didn't just sort it as
1
1
1
2
2
2
.
.
.
10
10
10

 

[Diablo II]

would need to know the info and the date and suff, to test it out, when you sort it will put it in order, if sam , tom . mark was in A it would sort it ot mark sam tom,

 

[teylyn]

Hi,

Excel will treat this as text:

1-Info
1-Info
1-Info
10-Stuff
10-Stuff
10-Stuff
2-Data
2-Data
2-Data

If you want Excel to sort correctly, you'll have to include a leading zero for the single digit numbers, like

01-Info
01-Info
01-Info
02-Data
02-Data
02-Data
10-Stuff
10-Stuff
10-Stuff


Teylyn

 

[largeselection]

Thanks for the replies.

I ended up just creating a custom list that was 1,1,1,2,2,2,3,3,3 etc.

Then i sorted by that to get it how I wanted.

Merging cells can be such a pain!