Good Morning

I have a field in a list that contains product descriptions and all begin with a number. For example 200 Steel Pipe or 250 Steel Bend. The list is not sorted at all but when I create my pivot table all the data is presented sorted by ascending number value. The quantities are obviousley in an adjacent column.

So this list
200 Steel Pipe 6
300 Steel Elbow 2
150 Steel Pipe 3
200 Steel Pipe 4
150 Steel Pipe 1
300 Steel Elbow 7

Would become like this in the pivot table (ie sorted numerically).
150 Steel Pipe 4
200 Steel Pipe 10
300 Steel Elbow 9

I need the data to appear in the pivot table in the same sequence as it appears in the list where in comes from as below.

200 Steel Pipe 10
300 Steel Elbow 9
150 Steel Pipe 4

Please advise a solution. I wondered if it ws the formatting of the description field, at the moment it's general.

Thanks