How to sort by specific values in a column?

How to sort by specific values in a column?

AbbottAbbott Posts: 1Questions: 1Answers: 0

Is there a way to sort by specific values in a column? For example, I want all "Ripe" to be on top in the example below, and then all "Pineapples" to be the next, and yes they are both in the same column. So "Ripe" takes priority, then "Pineapples", then the rest I guess naturally would be in alphabetical order.

Column1..Column2..Column3..Column4(fruit, freshness)
Tina..........MA...........28............Pineapples Ripe
Yael.........WA...........52.............Apples Ripe
Doro.........PA............23............Grapes Ripe
Andy.........PA............23............Pineapples Raw
Joel..........NY............37............Pineapples Raw
Mike.........WA...........52............Pineapples
Matt..........NY............37............Apples
Quan........MA...........28............Grapes

They are both in the same column. Any help is appreciated, thank you!

Answers

Sign In or Register to comment.