I'm a teacher and I have a vocabulary database of common English words--and the many derivatives of those words--that I want to teach my ESL students.
I've manipulated the database to the point that it looks like this:
<tbody>
</tbody>
However, I'd like group the data by word form into rows, like this:
<tbody>
</tbody>
I know that the formula or macro will involve finding partial matches throughout the entire spread sheet and then creating a command to move the partially matching cells into a single row, but as a novice Excel user, I have no idea how to even begin developing such a formula.
If any one can provide any guidance on this problem, I'd be most appreciative.
I've manipulated the database to the point that it looks like this:
Singular Noun | Plural Noun | Base Verb Form | First Person Singular Verb Form | Present Participle | Past Participle | Adjective | Comparative Form |
| | | | | | | |
ability | | | | | | | |
| abilities | | | | | | |
inability | | | | | | | |
| | | | | | able | |
| | | | | | | abler |
| | | | | | | |
| | | | | | | |
| | | | | | unable | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
absence | | | | | | | |
| absences | | | | | | |
| | absent | | | | | |
<tbody>
</tbody>
However, I'd like group the data by word form into rows, like this:
Singular Noun | Plural Noun | Base Verb Form | First Person Singular Verb Form | Present Participle | Past Participle | Adjective | Comparative Form |
| | | | | | | |
ability | abilities | | | | | able | abler |
inability | | | | | unable | | |
absence | absences | absent | | | | | |
<tbody>
</tbody>
I know that the formula or macro will involve finding partial matches throughout the entire spread sheet and then creating a command to move the partially matching cells into a single row, but as a novice Excel user, I have no idea how to even begin developing such a formula.
If any one can provide any guidance on this problem, I'd be most appreciative.