If you have column A and B. A has titles (ie Monday, Tuesday, . . .) and B has lines of data associated with the column label in A. How can you filter by the title in column A but display all the associated data in column B? I have about 15 rows in B associated with each name in column A but can not get the filter to display more than one column. I would be estatic if anyone could solve this. I have read the Excel help topics ten times (literally) to no avail.