Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi,
Have you tried the Data > Group and Outline feature?
Grouping data in Excel 2003
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I am using Excel 2003 and have a spreadsheet that has a large list of equipment names and test results. The test results are listed in columns corresponding to each month of the year and are text such as GOOD, NOT TESTED, WARNING, ALERT, etc. I want to be able to group the data in such a manner as to be able to click on a name for a particular piece of equipment and display that equipment's data. I have tried using Pivot Tables but that does not seem to work for text data, it just gives me totals for however many text entries I have listed. Can anyone suggest a way to do this?
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.