Hello,
I have a table that contains part numbers in one column and data about the part number in the other.
The part numbers looks like these:
3bk12345-000
3bk12345-001
3bk54321-000
3bk54321-001
The lust 3 digits (after the dash) are version of the part number.
I would like to group the part numbers rows based on the part number and ignoring three digits after the dash.
Thanks.
Bookmarks