Is there a way to group clients, with multiple rows, according to an item in one field but based on a value in another field?

Example - need to group clients according to favorite item but keep all rows for client together and in original order. Favorite item may not be listed first.

How data appears:
ID     client     item     color     favorite
1     SMITH     FUTON     W     Y
1     SMITH     COUCH     B     N
1     SMITH     COUCH     B     N
2     JONES     CHAIR     R     N
2     JONES     COUCH     B     Y
2     JONES     COUCH     B     N
2     JONES     COUCH     B     N
2     JONES     FUTON     W     N
3     JOHNSON     CHAIR     R     Y
3     JOHNSON     COUCH     B     N
4     HOWARD     CHAIR     R     N
4     HOWARD     COUCH     B     Y

How need it to appear:                    
ID     name     item     color     favorite
COUCH                    
2     JONES     CHAIR     R     N
2     JONES     COUCH     B     Y
2     JONES     COUCH     B     N
2     JONES     COUCH     B     N
2     JONES     FUTON     W     N
4     HOWARD     CHAIR     R     N
4     HOWARD     COUCH     B     Y
FUTON                    
1     SMITH     FUTON     W     Y
1     SMITH     COUCH     B     N
1     SMITH     COUCH     B     N
CHAIR                    
3     JOHNSON     CHAIR     R     Y
3     JOHNSON     COUCH     B     N

Thanks for any help!

Edited by SNelson - 24 Jan 2017 at 5:19am

Yes, all have a favorite item. Some clients just have one row, which is the favorite.

Stephanie

You're right - this gets complicated!
There are 5 views that are joined (inner) by ID. View1 links to view2, view 2 to 3 and onward through view 5.
There are two additional links that join the views and follow the same progression, one begins at view2 and the next at view3. These fields are not used in the example above but are used to sort and keep the records in order by ID (sort1 & sort2):
ID     client     item     color     fav     sort1     sort2
1     SMITH     FUTON     W     Y     1     1
1     SMITH     COUCH     B     N     2     1
1     SMITH     COUCH     B     N     2     2
2     JONES     CHAIR     R     N     1     1
2     JONES     COUCH     B     Y     2     1
2     JONES     COUCH     B     N     2     2
2     JONES     COUCH     B     N     2     3
2     JONES     FUTON     W     N     3     1
3     JOHNSON     CHAIR     R     Y     1     1
3     JOHNSON     COUCH     B     N     2     1
4     HOWARD     CHAIR     R     N     1     1
4     HOWARD     COUCH     B     Y     2     1

Thank you - I will try copying the view and including the links! Looking forwarding to trying it.