Merge data in cells vertically if the last cell in the merge always ends in a price?

[Perodin]

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
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]1[/TD]
[TD]3935 Body Clip (Mounting Clip), Angled, 90-Degrees (10) ........................ $3.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3934 Body Clips, Heavy Duty (12) ............................................................ $3.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1914R Body Mount, Front & Rear (Black)/ Body Posts, 52Mm (2),[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]38Mm (2), 25Mm (2), 6.5Mm (2)/ Body Post Extensions (2)/[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Hardware ........................................................................................ $6.00[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]1815 Body Washers (8) ........................................................................... $2.00[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]6811 Body, Slash 4X4 (Clear, Untrimmed, Requires Painting)/[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Window Masks/ Decal Sheet ........................................................ $35.00[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]6817 Body, Slash 4X4, Amsoil (Painted, Decals Applied) .................. $60.00[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]6831 Body, Slash 4X4, Chad Hord (Painted, Decals Applied) ............ $60.00[/TD]
[/TR]
</tbody>[/TABLE]

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
[TABLE="class: grid, width: 950"]
<tbody>[TR]
[TD]1[/TD]
[TD]3935 Body Clip (Mounting Clip), Angled, 90-Degrees (10)[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3934 Body Clips, Heavy Duty (12)[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1914R Body Mount, Front & Rear (Black)/ Body Posts, 52Mm (2), 38Mm (2), 25Mm (2), 6.5Mm (2)/ Body Post Extensions (2)/ Hardware[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1815 Body Washers (8)[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]6811 Body, Slash 4X4 (Clear, Untrimmed, Requires Painting)/ Window Masks/ Decal Sheet[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]6817 Body, Slash 4X4, Amsoil (Painted, Decals Applied)[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]6831 Body, Slash 4X4, Chad Hord (Painted, Decals Applied)[/TD]
[/TR]
</tbody>[/TABLE]

Thank you in advance for any help provided, it is much appreciated!

 

[Capt.Ragnar]

It can be done but not through a single formula that I know of.

 

[Perodin]

It can be done but not through a single formula that I know of.

I am more than happy to use more than one formula or step if I can get the proper results.

 

[Capt.Ragnar]

Ok. Assuming your data starts in A1:

In C1: =IFERROR(IF(AND(LEFT(B1,4)/LEFT(B1,4)=1,RIGHT(B1,3)=".00"),0,1),1)
In D1: =IF(OR(C1=0,C1=1),B1,"")
In E1: =IF($C2=2,$B2,"")
In F1: =IF($C3=3,$B3,"")
In G1: =IF($C4=4,$B4,"")
In H1: =CONCATENATE(D1,E1,F1,G1)
In I1: =IFERROR(LEFT(H1,FIND(" .",H1,1)),"")

That will leave you with what you want in column I.

If you copy column I and paste as values in another worksheet you can sort and remove the blanks.

 

[shuklaankur281190]

you just need to enter below formula

=IF(ISERROR(LEFT(A1,FIND(" .",A1)-1)),"",LEFT(A1,FIND(".",A1)-1))