Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an excel spreadsheet with 3 columns. The first column is merged downwards to be the length of the other cells and contains a document name. The other 2 columns contain an id and some text respectively.

The spreadsheet ultimately will contain extracts from about 100 documents and I would like to be able to filter by document to see the document specific rows, however when I try to set up filtering, I can only return the first row per document name.

Is there any other way to accomplish this task? I tried using grouping however I didn't really understand it.

share|improve this question
up vote 1 down vote accepted

In Excel, merging multiple cells into one cell will keep the upper-left most data only. For example, if you merge the range A2:A6, only A2 will keep its value and A3:A6 will be blank. So, merged cells will be troublesome in your case. Instead, you can unmerge the cells in your first column, fill them with the related values (document names), and then use Filtering. Moreover, you can also use Pivot Tables (Insert > Pivot Table). Drag your first column's header (Document name) to Row Labels (in the Pivot Table Field List), and other column headers to Column Labels. You can change the design of your Pivot Table in whatever way you like.

share|improve this answer
Thank you this is exactly what I needed. – ryangavin Jun 29 '10 at 20:08
You're welcome. – Mehper C. Palavuzlar Jun 29 '10 at 20:41

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .