Is there a way to merge data in cells vertically if the last cell in the merge always ends in a price?
In this case I have thousands of entries as shown below, and I would like to end up with consolidated rows.
3, 4, and 5 as a single entry
7 and 8 as a single entry
Leaving me (in this example) with 7 rows containing information
<tbody>
</tbody>
My Thoughts:
I assume this will require a qualifier that denotes the last cell always ending in a period followed by 2 numbers. I believe one could also use a qualifier that denotes the last cell containing a $ symbol.
I will also understand if this process would be better achieved by using the function more than once. The first time to merge rows 4 and 5, and 7 and 8. Then again to merge row 3 and the new row 4 that would be created by the previous function.
After this it would be nice to eliminate the prices and periods too, however I believe this data must remain intact until the merge is complete as it is the only thing that notes separation. I thought i would mention it, but I do not expect help with that in this post.
Ideal Results
<tbody>
</tbody>
Thank you in advance for any help provided, it is much appreciated!
In this case I have thousands of entries as shown below, and I would like to end up with consolidated rows.
3, 4, and 5 as a single entry
7 and 8 as a single entry
Leaving me (in this example) with 7 rows containing information
| 1 | 3935 Body Clip (Mounting Clip), Angled, 90-Degrees (10) ........................ $3.00 |
| 2 | 3934 Body Clips, Heavy Duty (12) ............................................................ $3.00 |
| 3 | 1914R Body Mount, Front & Rear (Black)/ Body Posts, 52Mm (2), |
| 4 | 38Mm (2), 25Mm (2), 6.5Mm (2)/ Body Post Extensions (2)/ |
| 5 | Hardware ........................................................................................ $6.00 |
| 6 | 1815 Body Washers (8) ........................................................................... $2.00 |
| 7 | 6811 Body, Slash 4X4 (Clear, Untrimmed, Requires Painting)/ |
| 8 | Window Masks/ Decal Sheet ........................................................ $35.00 |
| 9 | 6817 Body, Slash 4X4, Amsoil (Painted, Decals Applied) .................. $60.00 |
| 10 | 6831 Body, Slash 4X4, Chad Hord (Painted, Decals Applied) ............ $60.00 |
<tbody>
</tbody>
My Thoughts:
I assume this will require a qualifier that denotes the last cell always ending in a period followed by 2 numbers. I believe one could also use a qualifier that denotes the last cell containing a $ symbol.
I will also understand if this process would be better achieved by using the function more than once. The first time to merge rows 4 and 5, and 7 and 8. Then again to merge row 3 and the new row 4 that would be created by the previous function.
After this it would be nice to eliminate the prices and periods too, however I believe this data must remain intact until the merge is complete as it is the only thing that notes separation. I thought i would mention it, but I do not expect help with that in this post.
Ideal Results
| 1 | 3935 Body Clip (Mounting Clip), Angled, 90-Degrees (10) |
| 2 | 3934 Body Clips, Heavy Duty (12) |
| 3 | 1914R Body Mount, Front & Rear (Black)/ Body Posts, 52Mm (2), 38Mm (2), 25Mm (2), 6.5Mm (2)/ Body Post Extensions (2)/ Hardware |
| 4 | 1815 Body Washers (8) |
| 5 | 6811 Body, Slash 4X4 (Clear, Untrimmed, Requires Painting)/ Window Masks/ Decal Sheet |
| 6 | 6817 Body, Slash 4X4, Amsoil (Painted, Decals Applied) |
| 7 | 6831 Body, Slash 4X4, Chad Hord (Painted, Decals Applied) |
<tbody>
</tbody>
Thank you in advance for any help provided, it is much appreciated!
