Excel 2013: Is it possible to collapse rows only in a specific column?
- by h7u9i
In my spreadsheet, I'm trying to figure out a way to collapse rows in a specific column.
Right now, if I do Data - Group - Group... - Rows, it'll collapse the entire row. I want to collapse rows only in a specific column.
Example:
|---------|----------|
| hi | + data |
|---------|----------|
| hello | + data2 |
|---------|----------|
| | |
|---------|----------|
| | |
And opening data 1 would turn into:
|---------|----------|
| hi | - data1 |
|---------|----------|
| hello | point1 |
|---------|----------|
| | point2 |
|---------|----------|
| | + data2 |
|---------|----------|
| | |
|---------|----------|
| | |
Is this possible to do in Excel?