I am certain someone can help me here. To start off lets assume you have
something that looks like this:

Cells: A4 = Extravert A5=Intravert A6=Passive A7=Other

Cells: A1 - A800 are the clients names, so A1 = Client #1, A2=Client #2, and
so forth. Each client answers a number 1 to 4 for the above A4 - A7. Now what
I would like to is be able to sort on each customer row A4 - A7 based on the
answers 1 - 4. So for example if Client #1 said 1 to a4, 2 to a6, 3 to a5,
and 4 to a7, then it would put data in that order and keep the title because
I am using the title on another page. I realize I might need to create more
columns which is fine. Any thoughts on a formula?