Hello All - My first time
I have data similar to the following:
<tbody>
</tbody>
<tbody>
</tbody>I need to produce a table that shows the total instances of each type of bird from all four columns such that:
<tbody>
</tbody>
I tried to create a pivot table, but it only counts the first column, or includes the last three each as a subcategory of the column right before it.
Does anyone know how to do this? Preferably using a pivot table, but, also with VBA if necessary.
Thank you in advance.
I have data similar to the following:
Column 1 | Column 2 | Column 3 | Column 4 |
Robin | Ostrich | Dove | |
Ostrich | Sparrow | ||
Dodo | Robin | Sparrow | Eagle |
Ostrich | Dove | ||
Sparrow | |||
Robin | Sparrow | ||
Dodo | Robin | ||
Ostrich | Dove | ||
Robin | Sparrow | Eagle | |
Dove | |||
<tbody>
</tbody>
<tbody>
</tbody>
Bird | Total |
Dove | 4 |
Robin | 5 |
Ostrich | 4 |
Sparrow | 5 |
Eagle | 1 |
Dodo | 2 |
Total | 21 |
<tbody>
</tbody>
I tried to create a pivot table, but it only counts the first column, or includes the last three each as a subcategory of the column right before it.
Does anyone know how to do this? Preferably using a pivot table, but, also with VBA if necessary.
Thank you in advance.