Best way to extract a range and list the first value by itself and then list it again with a range

[Kurt]

I have the following data:

Coluimn A Column B

15CJ1R1 - 6.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 8.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 10.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 12.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 14.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 16.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 18.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 20.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 24.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 1/2" Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , PE
15CJ1R1 - 3/4" Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , PE
15CJ1R1 - 1.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , PE
15CJ1R1 - 1.50 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , PE
15CJ1R1 - 2.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 3.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 4.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 6.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 8.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 10.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 12.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 14.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 16.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 18.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 20.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE
15CJ1R1 - 24.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE

In the first example I need 15CJ1R1 - 6.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE listed once

Like this

Size Description
6 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE listed once
6-24 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE listed once

1/2 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , PE
1/2 - 24 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , PE

Inches need to be without the " sign.

I have looked at several examples of Sorts, Arrays and Unique Filtered lists.

Can someone explain if a formula is just as fast or if vba code would be faster?

I can't wait until I see the responses. In 15 years of using Mr. Excel this forum has never let me down and I have made several freinds on this forum.