Expert: Richard Stephens - 7/17/2008

Question
Hi,

I am having a problem with Excel concerning the appearance of multiple values.

I have on sheet which states for example:

Jonathan         Great
Jonathan         Great
Jonathan         Great Story
Jonathan         Great Story Cool
Jonathan         Mega

Imagine I want the row to only show me:

Jonathan         Great Story Cool Mega

How would you go about doing it for every entry as there is not only my name but multiple ones with rows that repeat themselves liek above, but I am only looking for a combined unique row of data, where all the data is extracted from another worksheet from the same workbook so that if the data is modified in the other sheet, the data in this sheet is automatically modified.

Thanks

Answer
Jonathan

You could use the filter data option under Data menu. You can use the Auto filter if you want to filter in place or the Advanced Filter to filter in place a create a new copy at another location.

http://www.contextures.com/xladvfilter01.html

Richard