Can I sort horizontally some how when I have merged cells?

**jasonmcbride** · 04-15-2012, 09:48 PM

It's probably easier to have a look at my simple example attachment to see what I am trying to achieve.
Thanks in advance
Cheers
Jase

Fullscreen capture 16042012 121416 PM.jpg

**Mallycat** · 04-16-2012, 03:33 AM

When you say sort, do you mean "move", or do you actually want Excel to do some type of "sorting"?

**jasonmcbride** · 04-16-2012, 06:00 AM

Originally Posted by Mallycat

When you say sort, do you mean "move", or do you actually want Excel to do some type of "sorting"?

I mean sort, I have a sheet with over 30 stores,(too many to move) the sheet I gave was just an example.

**jasonmcbride** · 04-16-2012, 06:14 PM

is this impossible?

**jasonmcbride** · 04-19-2012, 03:41 AM

I guess not

**Marcol** · 04-19-2012, 06:14 AM

Try this long-hand way, it might give you a start.

1/. Define a Dynamic Named Range "Managers"
Refers to:=

Please Login or Register  to view this content.

2/. In a spare sheet (Sheet3 in this example workbook)
In A1

Please Login or Register  to view this content.

In B1

Please Login or Register  to view this content.

Drag/Fill both Down until a #REF! error appears in Column A

3/. Follow the instructions in Sheet3!C:C

4/. In Sheet2 of this example
In B3

Please Login or Register  to view this content.

Drag Across and Down as required.

5/. Copy the result and Paste Special > Values to your required destination.

I'll leave you to format the result as you wish, I would not use merged cells, they are nothing but trouble.

Maybe later someone will convert all of this via a macro for you.

Hope this helps.