hi all,

i have a simple spreadsheet as follows:

excel row,name,type
1,john,email
2, , phone
3,cathy,pager
4, , cell phone

I want to sort by type.
The problem is 2 rows represent a person. The column Name is merged, which
takes up 2 rows. But the Column type can have either merged cells or
individual cells.

Anyone know of different ways to solve this?

thanks,
rodchar