Sort merged and unmerged cells

[Josh O.]

I am trying to sort several columns of data alphabetically using column A

The problem is that I have the first three and last column as merged cells

Is there any way to sort the data?

 

[RagDyeR]

Sure!

Unmerge the cells.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am trying to sort several columns of data alphabetically using column A.

The problem is that I have the first three and last column as merged cells.

Is there any way to sort the data?

 

[Josh O.]

Ideally that would work, but when I unmerge the cells then sort, I don'
know how to keep the rows grouped together.

For example:

Row 1 includes a quantity.
Row 2 includes the expanded price calculated from the quantity.

Any ideas

 

[Bernie Deitrick]

Josh,

Redesign your table, and keep all calulcations except summaries on the same
line as the data. Each line should be a separate data point, with all
necessary identifications in separate cells in that row. Basically, you want
to make a database - that way you can sort your data, create automatic
summaries using Pivot tables, and use data filtering for easy presentation
of your data.

HTH,
Bernie
MS Excel MVP