I have a table containing an identifier which always starts AB (unique) and a key value (non-unique)

```
ID       Key
------------------
AB1234   10001
28376    10001
AB5678   10002
7180     10002

```

I need to be able to query and get single row results for each Key value. There will always only be two different ID values per key so I require the following results:

```
ID1      ID2      Key
----------------------------
AB1234   28376    10001
AB5678   7180     10002

```

I'm not even sure if this is possible or not