I have a table of parts that looks like this:

| Part | Part Num | Thing1 | Thing2 | Thing3 | Thing4 |
| --- | --- | --- | --- | --- | --- |
| Door | **101053**22 | abc | abc |  |  |
| Door | **101053**23 | abc | abc |  |  |
| Door | **101053**24 | abc | abc |  |  |
| Door | **846251**11 | abc | abc | abc |  |
| Door | **846251**18 | abc | abc | abc |  |
| Door | **846251**85 | abc | abc |  | abc |
| Door | **568971**01 | abc | abc |  |  |

The part number is always 8 characters. For many parts, the first 6 characters are the same, and the last 2 are different. Lines where the first 6 characters of a part number are the same and all rows that have the same values in Thing1/Thing2/Thing3/Thing4 need to be combined, and the part number becomes 6 characters. (row 1/2/3 in the above table)

Lines where the first 6 characters are the same but the values in Thing1/Thing2/Thing3/Thing4 are NOT identical in all rows need to remain unchanged and the part number remains 8 characters. (row 4/5/6 in the above table)

Lines where the first 6 characters are unique need to remain unchanged and the part number remains 8 characters. (row 7 in the above table)

The desired result would look like:

| Part | Part Num | Thing1 | Thing2 | Thing3 | Thing4 |
| --- | --- | --- | --- | --- | --- |
| Door | **101053** | abc | abc |  |  |
| Door | **846251**11 | abc | abc | abc |  |
| Door | **846251**18 | abc | abc | abc |  |
| Door | **846251**85 | abc | abc |  | abc |
| Door | **568971**01 | abc | abc |  |  |