我在甲骨文有一张table，这张table已经从一些更大的table上取走了

+---------------+------------+
| shop   number | Model Type |  
+---------------+------------+
| 1             | Mod-1      |  
+---------------+------------+
| 1             | Mod-2      |  
+---------------+------------+
| 2             | Mod-3      | 
+---------------+------------+
| 2             | Mod-3      | 
+---------------+------------+
| 3             | Mod-4      |
+---------------+------------+
| 3             | Mod-5      |
+---------------+------------+
| 4             | Mod-1      |
+---------------+------------+
| 4             | Mod-2      | 
+---------------+------------+
| 4             | Mod-6      | 
+---------------+------------+
| 4             | Mod-3      |
+---------------+------------+
| 5             | Mod-1      |
+---------------+------------+

实际上，这是将基于shop的行组合在一个位置，并在此基础上生成两个不同的列，结果应该如下所示

+---------------+---------------------------------+-----------+
| shop   Number | Shop Type                       | Shop Type |
+---------------+---------------------------------+-----------+
| 1             | Mod-1 & Mod-2                    | Mix       |
+---------------+---------------------------------+-----------+
| 2             | Mod-3                           | Mod-3     |
+---------------+---------------------------------+-----------+
| 3             | Mod-4 & Mod-5                   | Mix       |
+---------------+---------------------------------+-----------+
| 4             | Mod-1 & Mod-2   & Mod-3 & Mod-6 | Mix       |
+---------------+---------------------------------+-----------+
| 5             | Mod-1                           | Mod-1     |
+---------------+---------------------------------+-----------+

不确定如何处理此问题。请帮助...