Sorting problem

Hi
I'm trying to help a colleague with a wbs challenge they have.
They want to show data in the following way, but the Sort function in Excel doesn't work properly with this if you try to sort using the WBF column. Looking at this example, the ultimate parent would be 1=Frame, below that you have 1,1=Headset (part of the Frame), then within the Hub you have 1,1,1=Headset Bearings......etc. Hope this makes sense and someone can suggest how this can be sorted numerically. Is there a different way the information in WBF column can be displayed that would sort properly? Incidentally in case you can't see the screenshot below properly, WBF is Col A with numberical values separated by Commas......Bike Item is the text description (Col B), which relates to corresponding numerical value in WBF Column.

Thanks
Wendy

WBF Bike Item
1 Frame
2 Wheel
1,1 Headset
1,1,1 Headset Bearings
2,1 Hub
2,2 Spoke
2,2,1 Spoke Nipple
1,2 Bottom Bracket
2,1,1 Cones
2,1,2 Hub Cones

Hi,

I think you'll need to split the WBF values out and then sort on the multiple columns:

Dom

Hi Wendy,

The problem is that 1.1.1 is no longer a number that excel recognizes. You need to convert all the column A numbers to Text using a formula like in C1 = A1 & ""
Pull this formula down for all the WBF numbers and then copy the result over the top of the values in column A. Then sort by WBF and you will get what you want.

See attached.