Hi All,
I'm really hoping somebody can help with this!
Here's an example to give you an idea of the structure I'm working with, values in B are on separate rows.
<tbody>
</tbody>
<tbody>
</tbody>
I'm really hoping somebody can help with this!
Here's an example to give you an idea of the structure I'm working with, values in B are on separate rows.
A | B |
Fruit | Banana |
Apple | |
Strawberry | |
Veg | Carrot |
Broccoli | |
Peas | |
Potatoes | |
Leeks |
<tbody>
</tbody>
So I need to combine the answers in B into a single cell like this
<tbody> </tbody> Now I can do this for each part number but have over 3,000 to do and they all have varying amounts of data to combine into 1 cell, it would take forever. There is a line space between each grouping just like the first table Does anybody know how I can achieve this quickly with a formula or VBA? Many thanks for any help!!! |
<tbody>
</tbody>
Last edited: