Example:List Name: "Test List" with the view "Allow users to order items in this view" set to "Yes"Data (in this order): - Item Z- Item 1- Item CDocument Library Name: "Test Doc Lib"Additional column: Lookup column to "Test List" Title columnData:File 1 I want the "Test Doc Lib" View to display in this format (with grouping):- Item Z File A File B- Item 1 File C- Item C No Items.Can this format be done by just configuring? The grouping must be in this sequence as the "Test List". Once "Test List" sequence changed, the grouping in "Test Doc Lib" also change. I'm using MOSS 2007Thanks in advance.

Hi Jingzo, As per your description you are looking for cascaded drop down columns. Unfortunately in MOSS 2007, OOTB it is not possible, it requires little coding. please refer http://datacogs.com/datablogs/archive/2007/08/26/641.aspx Also please take a look @ http://debugmode.net/2010/02/05/cascading-drop-down-column-in-a-sharepoint-2007-list/Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/

Give a short to SharePoint View Boost,(BTW,a stupid name) it allows you to expand or collapse columns. It is also free.