Sort merged and unmerged cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
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
 
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
 
Back
Top