Create a group based on the numeric values

[GSG]

Hello All,

I am seeking help to create a group based on numeric values. I have data values like 101, 101 BD, 102, 102BD and so on. I want to create a group based on numbers. The groups would be like 101, 102, 103 and so on. Please advise. I would appreciate your help. Thanks

[GSG]

Thank you Abhilash, the provided solution works for me.