Hello Excel experts,
I have a single yet very long column with several blocks. Each block has a header/category name and each block is separated from the next block with 1-3 new lines. My data is similar to:
<tbody>
</tbody>
I would like to know how many items are within each block, along with the block name. So, my desired output is:
<tbody>
</tbody>
<tbody>
</tbody>
OR
<tbody>
</tbody>
I would prefer a formula, if possible. Thank you!
I have a single yet very long column with several blocks. Each block has a header/category name and each block is separated from the next block with 1-3 new lines. My data is similar to:
Fruits |
Apple |
Banana |
Orange |
Grapes |
Pineapple |
Veggies |
Celery |
Carrots |
Spinach |
Nuts |
Pecan |
Walnut |
<tbody>
</tbody>
I would like to know how many items are within each block, along with the block name. So, my desired output is:
<tbody>
</tbody>
Fruits | 5 |
Veggies | 3 |
Nuts | 2 |
<tbody>
</tbody>
OR
Fruits - 5 |
Veggies - 3 |
Nuts - 2 |
<tbody>
</tbody>
I would prefer a formula, if possible. Thank you!